How to sum SubTasks story Points and compare with Story SP

[Vikas Srivastava]

I have to write an automation rule which will do the following

Trigger -  When a story is re-estimated (Story Point is updated)

1. Sum all SP from SubTasks which are not one or Cancelled

2. Compare with Story SP

3. If mismatch is there then write a comment. 

e,g,

User Story Story point = 4

  SubTask 1 - Status In Progress  - Story Point = 2

  SubTask 2 - Status Cancelled  - Story Point = 2

  SubTask 3 - Status In Progress  - Story Point = 4

Since there is mismatch between Parent US (4) and Sum and Active SubTasks (6) I want to put a comment. 

I could compare 

SubTasks points {{issue.subtasks.Story Points.sum}}  AND Story Point {{issue.Story Points}}. But how to exclude Done or Cancelled SubTasks is something I am not able to figure out. 

I am sure it is simple tweak. :-)

Please help.  

[Trudy Claspill · Accepted solution]

Hello @Vikas Srivastava 

Welcome to the Atlassian community.

Please show us your complete automation rule as you have currently built it.

How are you intending for this rule to be triggered?

[Vikas Srivastava]

Just added a snapshot. 

[Trudy Claspill]

After the Condition where you are checking the Status of the trigger issue you can add a Lookup Issue Action to lookup the subtasks of that issue based on a JQL statement, retrieving only the subtasks that are not in a Cancelled status.

You could then use the smart value {{lookupIssues.Story Points.sum}} in the Compare Values condition rather than {{issue.subtasks.Story Points.sum}}

[Vikas Srivastava]

let me try :-)

[Vikas Srivastava]

It worked. Thanks a lot. 

[Trudy Claspill]

I'm glad I could help you.

If your problem has been solved, please consider marking the Answer as Accepted.

[Vikas Srivastava]

Hi Trudy, 

Now, I have to run the same rule on all stories at a scheduled time to get a report out of all the mismatches. 

I have the JQL for getting the get impacted stories and compare then report all issues in an email to me. 

[Vikas Srivastava]