Structure in Jira - cannot Sum over sub-items when applying colors

[Nadya_BA]

Hey all,

I have this structure below.
I would like each level to take the sum of the children.
Which means: feature level will display the sum of the values of epics and epics will display the sum of children. 
Taking into account that children display the value of story points when they are flagged.

it works if I do it this way:

However, the sum does not show in epic and feature level (they remain empty), if I apply colors using wiki markup and 'sum over sub-items' option.

Can you help, please?

[David Niro · Accepted solution]

Hello @Nadya_BA ,

David from ALM Works here.

Sum over sub-items is designed to quickly aggregate numeric values.  When introducing wiki markup, the value in the field is no longer just a number.

We can still accomplish your goal.  It just requires a more complex formula.  I have provided an example below that should work for you if I understand your hierarchy Feature > Epic > Story correctly.

WITH FORMAT_COLOR(color,value) = 
  """{color:$color}$value{color}"""
:

IF (issuetype = "Story";
  FORMAT_COLOR("red",IF(flagged;
    storypoints)
  );
issuetype = "Epic";
  FORMAT_COLOR("red",SUM#children{IF(flagged;
    storypoints)}
  );
issuetype = "Feature";
  FORMAT_Color("red",SUM#leaves{IF(flagged;
    storypoints)}
  )
)

It may require some adjustments. Please let me know if it helps!

Also, feel free to contact our support team directly via email support@almworks.com or through our customer portal support.almworks.com.

Best,
David 

[Nadya_BA]

@David Niro It works like a charm. Thanks a lot David!