Sum automation rule does not work

Jakobus Johannes de Swardt

Hello there

We're using a team managed project and are attempting to sum the story points of the "Story point estimate" field into a new numerical field "Story point sum". We've setup our automation as specified in this post.

The formula seems to run through all the steps up until it has to SUM the "Story point estimate" fields. 

Background on our project - issue structure: 

• We've renamed our Epic to "Milestone" 
• We have 2 task types renamed to "CS task" and "Marketing task"
• No story or Bug types
• We still have Sub-tasks

Snapshot of the project:

 

Rule setup in Jira: 

{{lookupissues.Story point estimate.sum}} 

 

Audit of the rule running: 

• It sees the value was changed correctly
• It looks up all the issues in the parent correctly
• It identifies that the parent should be edited correctly
• It doesn't seem to SUM the fields and the "Story points sum" field stays blank. 

 

If someone could assist it would be greatly appreciated! 

 

Cheers

 

Bill Sheboy

Hi @Jakobus Johannes de Swardt 

I note in your edit action that you have capitalized the smart value incorrectly, and those are case-sensitive.  Please try instead:

{{lookupIssues.Story point estimate.sum|0}}

I also added a null check so you always get a number if there are not values yet.

Kind regards,
Bill