Help with Automating Risk Score Calculation in Jira

Question

Hi everyone,

I'm trying to automate the calculation of the Risk Score field in Jira. The Risk Score is a numeric field, calculated by multiplying Probability and Impact, both of which are dropdown fields with values like Low (green circle), Medium (orange circle), and High (red circle). It is text + emoji circle color

I set up a lookup table for both fields where:

* Low = 1
* Medium = 2
* High = 3

However, my automation rule isn't working as expected. Can anyone guide me on how to properly set this up so that the Risk Score field is automatically calculated by multiplying the values for Probability and Impact?

Thanks in advance for your help!

Bill Sheboy · Answer

Hi @Bachir AMMACHE

Just following up to check if this or Kelly's response answered your question.  If so, please consider marking them as "answered".  That will help others with a similar need find solutions faster.  If not, please let the community know what help you need with the rule changes.

Thanks!

Bill Sheboy · Answer

Hi @Bachir AMMACHE

For a question like this, context is important for the community to help.  Please post the following:

* what type of project is this (e.g., company-managed, team-managed, etc.), 
* an image of your complete automation rule,
* images of any relevant actions / conditions / branches,
* an image of the audit log details showing the rule execution, and
* explain what is not working as expected.

Until we see those...

You describe the Probability and Impact fields are single-selection, option fields and that you are using Lookup Tables to translate the options to numbers to perform the calculation.

To get the values from the fields, the value attribute is used.

Assuming the lookup tables are named varProbabilityToScore and varImpactToScore, a math expression could produce the result with this:

{{#=}}{{varProbabilityToScore.get(issue.Probability.value)}} * {{varImpactToScore.get(issue.Impact.value)}}{{/}}

Kind regards,
Bill

Bachir AMMACHE · Answer

Hello , the rule worked well when I changed my costum fields from dropdown to text fields , ( dropdown includes circles emojis ) but I actually need it for dropdown