How to sum SubTasks story Points and compare with Story SP

Vikas Srivastava_bcbiyk

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 P Claspill

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?