Automation to sum a filed from all the childrens of the same initiative

[Eran Roiter]

Hey all,

I want to create an automation in Jira:
every time a child (Epics) "Name of a field" is updated, sum that field from all the children's of the same initiative and update that field for the parent issues.

I tried and added a log at the end of the automation i built, and for some reason it returns this: Lookup Issues Count: 23, Total DL Story Points: 0

Even though the field is not 0 in some of the epics. 

Thanks for your help ! 

[John Funk · Accepted solution]

Hi Eran,

See if this article helps you. 

https://community.atlassian.com/t5/Jira-articles/How-Can-I-Sum-Up-Multiple-Issues-into-a-Parent-Number-Field/ba-p/2882712

[Bill Sheboy]

Hi @Eran Roiter 

Adding to the suggestion from @John Funk 

The article John provides uses a scheduled trigger rule, perhaps updating the summed field once per day.

When an update is needed more often, multiple rules with different triggers are needed.  The specifics of which rules to add depend upon how accurately you want the sum to be tracked.  For example:

1. when the field changes in a child issue, update the parent
2. when a new child is added to a parent, update the parent
3. when a child is removed from a parent, update the parent
4. (combining #2 and #3) when a child issue is moved to a new parent, update both parents
5. (edge case) when a child issue is deleted from Jira, update the parent
6. (edge case) when a person manually changes the field in the parent, recalculate the sum from the child issues
7. etc.

Kind regards,
Bill

[Eran Roiter]

Thank you guys !