Goal is to compute percent complete for Sprint Story points

Question

Team

I have 2 rules

1. that gives me the total # of story points for all issues within a Sprint after the Sprint ends and

2. that gives me the # of story points for all issues that are in Done status after the Sprint ends

I am trying to compute the percent complete using this formula

% complete (at the end of Sprint) = Story points estimate completed/Total Story points estimate

Here's what I have an automation rule crafted so far, but have not had success with computing the percent complete

Any pointers would be greatly appreciated

There are no errors when the rule runs.

But the email simple outputs the formula. not the computed values

Thanks

KD

Bill Sheboy · Answer

Hi @Dipen

This is a frequent question in the community, and you may calculate the percentage complete (by story points) using one Lookup Issues action and no Created Variables for intermediate steps.  To do this, please see this earlier post:

https://community.atlassian.com/t5/Automation-questions/Re-Calculating-percent-complete-based-on-story-point-wei/qaq-p/2624238/comment-id/9570#M9570

In your case, you are using a team-managed project, so substitute the smart value Story point estimate rather than Story points in the expression.

Kind regards,
Bill

Trudy P Claspill · Answer

Your syntax in your email is also incorrect. You need to treat those variables like Smart Values, with curly brace surrounds and following the required syntax for using math expressions with Smart Values.

https://support.atlassian.com/cloud-automation/docs/jira-smart-values-math-expressions/

In addition, you might need to convert them using the asNumber function, as I mentioned in my previous response.

Dipen_kozlm6 · Answer

Trudy

Here are the responses to the questions you posted in the message

1.details of your second Create Variable action.

2.details of send email action

Working on log Actions.

Will update you shortly on that

Thanks

KD