Summary PBIs

Dec 5, 2011 at 10:59 PM
Edited Dec 5, 2011 at 11:00 PM

We are rolling up task Estimated Effort fields into their associated PBIs using the AggregateRule :

 

<AggregateRule type="Sum">

	<WorkItemType source="Sprint Backlog Task" target="Product Backlog Item" />   

	<Link linktypename="Scrum.ImplementedBy" isforward="true" />

	<Field source="Scrum.v3.EstimatedEffort" target="Custom.EstimatedWorkRollup" />

	<ChangeNote>ATTEMPT AT SUMMING ALL CHILD SBT Scrum.v3.EstimatedEffort into PBI Custom.EstimatedWorkRollup</ChangeNote>

	<ExcludedSourceStates>

		<State>Deleted</State>

	</ExcludedSourceStates> 

</AggregateRule>

 

 

This works correctly.

However, we also want to roll-up child PBI Effort into another custom field on their parent PBI:

<AggregateRule type="Sum">

<WorkItemType source="Product Backlog Item" target="Product Backlog Item"/>

  <Link linktypename="Scrum.ImplementedBy" isforward="true" />

<Field source="Custom.EstimatedWorkRolluptarget="Custom.TotalEstimatedWork/>

<ChangeNote>ATTEMPT AT SUMMING ALL CHILD PBI Custom.EstimatedWorkRollup into PBI Custom.TotalEstimatedWork</ChangeNote>

<ExcludedSourceStates>

<State>Deleted</State>

</ExcludedSourceStates>

</AggregateRule>

This seems to work when a new child PBI is added, but not when the Custom.EstimatedWorkRollup field changes (which seems to be one of the criteria; see "What Changes Trigger an Update?").

Pointers appreciated!