Help with Automating Risk Score Calculation in Jira

[Bachir AMMACHE]

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]

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

[Kelly Arrey]

Hi @Bachir AMMACHE, 

Can you share screen shots of the relevant details of your current rule?

Thanks,

[Bachir AMMACHE]

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