Sum up story points to the epic

[Ori Gal]

Hellow Jira savvies,

Based on several community guides, I've created an automated rule to calculate the story points under an epic, and update the epic story points filed accordingly. 

The rule seems to be working, but nothing changed in the Epic story points field:

My Automation rule:

1. 

2. 

3. 

4. 

I will appreciate your input on where the problem is at.

Thanks,

Ori

[Jack Brickey · Accepted solution]

I believe the issue is with the use of "subtasks". Task, Story and Bug types are not "subtasks". Try the following...

{{lookupIssues.Story Points.sum}}

[Jack Brickey]

There are several posts discussing the method. Here is one I found where Bill did a good job of providing details. How-do-you-sum-up-story-points-to-the-epic-using-jira-automation . There are a couple others in the links under Related content to the right.

[Ori Gal]

Hi Jack,

I've updated the rule with your code but no change.

I will try to find the answer in other posts.

Thank you for your help!

[Jack Brickey]

Yes follow that other thread and let me know if you get stuck. I can create a rule and test for you later today when I have a moment.

[Ori Gal]

That would be amazing!

I followed the post you shared and the result is the same. 

could it be related to the fact that I'm using Jira Could?

[Jack Brickey]

No it should work for cloud just fine. Here is another thread offering a solution.

[Bill Sheboy]

Hi @Ori Gal 

Before your Branch please try adding a Lookup Issues action with JQL to match the sibling issues (with the same epic parent).  Then your edit should work.

Please note: 

• if you are using a Company-managed project, the JQL match is on Epic Link, and
• if you are using a Team-managed project, the match is on parent

Kind regards,
Bill

[Ori Gal]

Hi Bill,

Should the lookup be something like this?

issuetype in (story) and "Epic Link" = "{{issue.Epic.Name}}

Thanks,

Ori

[Bill Sheboy]

Assuming your trigger issue is a Story that is in an epic, please try to match on the key, such as:

issueType IN (Story) AND "Epic Link" = {{triggerIssue.Epic Link}}

I encourage you to review the linked post that Jack provided as there are some edge-cases to watch for.

[Ori Gal]

Bill, it worked. Thank you very much!

[lee_runyon]

Can u post the JQL as a script so others can use?