Sum of a numeric field in the sub-tasks of issue

Questions & Answers
1

Hello,
I would like to sum for each issue some numeric field that exists in the sub-tasks of the issues.
I tried something like this:
Sum(
[Issue].[Issue].GetmembersByKeys(
[Issue].CurrentHierarchyMember.get(‘Sub-task keys’)
),
[Issue.Sub-task].CurrentMember.get(‘Original Estimated Effort (Work Days)’)
)
But it doesn’t work.
Can you help please?

2

Actually it works fine.

3

Hello Ran

It is great you get this working!

I would suggest a slight change to the formula to get it more universal. You could use [Issue].CurrentHierarchyMember instead of [Issue.Sub-task].CurrentMember:

Sum(
[Issue].[Issue].GetmembersByKeys(
[Issue].CurrentHierarchyMember.get(‘Sub-task keys’)
),
[Issue].CurrentHierarchyMember.get(‘Original Estimated Effort (Work Days)’)
)

The formula works at Issue level only.

Daina/support@eazybi.com