Constants and large Calculations

Nov 1, 2011 at 1:45 AM

I need to build an algorithm like this.

(Field1Value * constant) + (Field2Value * constant) + (Field3Value * constant)

Then the result placed into the Target item?

Can this be done with the TFS aggregator?

Coordinator
Nov 1, 2011 at 3:00 PM

While this is would be very easy to do, I think I would have to make some modifications to the code to allow two different operations in one expression.

Right now my paying job is just too demanding for me to devote time to this project.  I hope to update it for TFS 11 after it has been fully released, but until then I don't think I will have time to get back to it.

I am sorry I cannot help you get this going.

Nov 1, 2011 at 3:17 PM
Edited Nov 1, 2011 at 3:18 PM

I completley understand, and thanks for the quick response.

Would it be possible to do it in stages, something like this? Also can you confirm if I have the correct syntax for multiply and for using a constant?

 

 

 

Thanks for the help.

  

 <AggregatorItem operationType="Numeric" operation="Product" linkType="Self" workItemType="Bug">
	  <TargetItem name="fields11"/>
	  <SourceItem name="field1"/>
	  <SourceItem value="200"/>
  </AggregatorItem>

  <AggregatorItem operationType="Numeric" operation="Product" linkType="Self" workItemType="Bug">
    <TargetItem name="fields21"/>
    <SourceItem name="field2"/>
    <SourceItem value="50"/>
  </AggregatorItem>
  
   <AggregatorItem operationType="Numeric" operation="Sum" linkType="Self" workItemType="Bug">
    <TargetItem name="FinalValue"/>
    <SourceItem name="field11"/>
    <SourceItem name="field21"/>
  </AggregatorItem>

 

 

Coordinator
Nov 1, 2011 at 3:25 PM

I am afraid that this will look for a field called "200" and a field called "field1".  Allowing constants is another change I would need to add in.