How reportable="measure" formula="sum" is working

Question

I have the field with [reportable="measure" formula="sum"] properties but im not able to get the sum after adding related / link items with values. May I know how the formula='Sum' is working ?

my field 

      <FIELD name="Estimated Effort (Scrum)" refname="Conchango.TeamSystem.Scrum.EstimatedEffort" type="Double" reportable="measure" formula="sum">

        <HELPTEXT>The estimated effort required to resolve this bug</HELPTEXT>

      </FIELD>

---

Muralidharan

Answer 1

Hi,

The 'Sum' simply refers to how the field in aggregated in the OLAP/Warehouse reports - You would be able to see sums in the Reporting section, but not in a Work Item Query.

E.g. if you would create a report, you would be able to see aggregate numbers for the Estimated Effort - for instance, a report for the Total Estimated Effort hours by Release will show a list with all the Releases and the Sum of the Estimated Effort for all work items in each release.

Thanks,
Alin,
PRAKTIK Consulting
TFS Hosting and TFS Consulting Services.

Answer 2

In this case, I like to have the field which should show the sum of Work Remaining field from releated work items, Is possible to have like this?

---

Muralidharan

Answer 3

Hi Muralidharan,

It is possible,  but you need to create custom wi control. In the control, use TFS API to get related workitems and then get the sum of specfied field.

Here is an article about how to create a custom wi control. You can display the initial value when set the value  m_workItem. And in Field Changed Event, if the specified field changed, you can calculate the value again.

Best Regards,
Ruiz

---

Please remember to click “Mark as Answer” on the post that helps you, and to click “Unmark as Answer” if a marked post does not actually answer your question. This can be beneficial to other community members reading the thread. Sincerely, Ruiz Yi