Hello,
We have added few custom fields in our Jira project and we wanted to calculate (sum) it in eazybi. However it’s not summing up.
formatted the fields already as decimal.
Thanks in advance.
Hello @Jim
You need to use “$total_aggregate” in your calculated members.
Something like this:
CASE WHEN
[Issue].CurrentHierarchyMember.Name <> "$total_aggregate"
THEN
/* ***
your calculated code for Efficiency, Value, toGoal, ... goes here
*** */
END
See How to customize the “Total” option with my defined formulation - #5 by asm89 for additional details.
Hope it helps!
Vasile S.
1 Like
Hi @Jim,
The values returned by the issue properties you have selected in the report return string values. I can tell by them being aligned to the left in the cell. Numeric values are aligned to the right.
Can you import these fields as measures? That would solve the problem you are facing. Please see the eazyBI documentation page for more details - Jira custom fields.
If you can’t import the fields as measures for various reasons, you can try to use the approach recommended by @VasileS. The formula could look similar to the one below:
CASE WHEN [Issue].CurrentHierarchyMember.Name <> "$total_aggregate"
THEN
Cast([Measures].[Issue Compliance related] as numeric)
ELSE
Sum(
VisibleRowsSet(),
Cast([Measures].[Issue Compliance related] as numeric)
)
END
The result could look similar to the one below:
Best,
Roberts // support@eazybi.com
2 Likes
Thank you VasileS and Roberts!! Working fine now!!!
1 Like