Summarize story points of open issues in parent

[Nicole Brückner]

Dear community,

I already found the automation rule for summarizing story points into the parent task. This works totally fine (For parent in edit field {{subtasks.Story Points.join(" + ")}}). 

Is there any possibility to sum those story points, where the issue is still open? 

Best regards-,

Nicole

[Bill Sheboy · Accepted solution]

Hi @Nicole Brückner 

What do you mean by "still open"?  Do you mean "not done"?

If so, an alternative method to what you show is to use smart value, list filtering with your math expression.  For example,

{{#=}}0{{#issue.subtasks}}{{#if(not(equals(status.name,"Done")))}}+{{Story points|0}}{{/}}{{/}}{{/}}

How this works:

1. The subtasks are iterated over
2. And a conditional filter checks for any where the status is not "Done" (Please adjust to match your status name.)
3. Returning only the matching story points, with a default value of 0
4. Finally wrapping that entire result as a math expression, with a default value of 0

Please look here to learn more about those techniques:

• https://community.atlassian.com/t5/Automation-articles/Filtering-smart-value-lists/ba-p/1827588
• https://confluence.atlassian.com/automation/jira-smart-values-math-expressions-993924866.html
• https://confluence.atlassian.com/automation/jira-smart-values-conditional-logic-1081351607.html

Kind regards,
Bill