I need some help, I tried to do a sum in EazyBI :
I need to do a sum of parent’s customs fields values, with a condition about a subtask.
Ex : If my parent has a subtaks in statut « To be estimated », So I do the sum of parent Custom field “TOTO” + another parent custom field “TATA”.
I tried with : [Issue].CurrentHierarchyMember.Parent.get … but I’m not an expert and I don’t work
Do you have an exemple of this type ? or an idea how can I do that ?
Thanks in advance,
You may want to use Issue dimension Sub-task hierarchy, and sum the custom field values from Parent level issues if the parent issue children contain issues in “To be estimated” status.
The calculation could be the following (use correct custom field names for issue properties “Issue TATA” and “Issue TOTO” and check the status name:
[Status].[To be estimated])>0
[Measures].[Issue TOTO]+ [Measures].[Issue TATA]