nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Automation Maths using Original Estimate

Phil Skade

So I'm trying to use Jira Automation to do a simple Value / Effort calculation.

We use a field "Priority Score" to represent value and we use the Jira "Original Estimate" field to represent the effort.

I want to divide one by the other.

After some trial and error I've landed on the following which is intended to populate the numeric field "Net Priority Score" whenever an issue is updated.

{{#=}}{{issue.fields.priority score.divide.issue.fields.originalestimate}}{{/}}

I look in the Automation audit log which proudly tells me "SUCCESS".

However when I then look at the issue I edited, the "Net Priority Score" is simply null.

I can confirm the 2 fields in the calculation both have values defined

Send help.

Accepted answers

Phil Skade

Resolved it with the following expression and putting the expression in the top box not the bottom one.. woops

{{#math}}{{issue.priority score}}/({{issue.original estimate}}/28800){{/math}}

All comments

Yong Yang

Hi @Phil Skade

please refer to this sample:

{{issue.timetracking.timeSpentSeconds.divide(3600).divide(issue.Request participants.size)}}

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

Maybe you can try:

You could test if score and estimate field vlaues can be got firstly if you have any issue.

Hope it helps.

YY哥

Bill Sheboy

Hi @Phil Skade

Please review the math expression documentation as your rule appears to have some errors: https://support.atlassian.com/cloud-automation/docs/jira-smart-values-math-expressions/

And also...Your rule's edit action has both selected the field from the dropdown list and is trying to update it with advanced edit with JSON. That is not possible: pick one method to update the field, such as using only the dropdown selection.

Kind regards,
Bill

Phil Skade

Thanks for the latter tip, moved the edit action up a box. Hasn't entirely fixed it but getting there.

Phil Skade

Resolved it with the following expression and putting the expression in the top box not the bottom one.. woops

{{#math}}{{issue.priority score}}/({{issue.original estimate}}/28800){{/math}}

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

jira

cloud

jira-cloud