Setting Up Jira Automation to Calculate 'Total Score' from Custom Fields

Fernando Garcia_yb0bms

In Jira Cloud, I have 3 custom fields: PII, PCI and PFI.

Each can be answered Yes or No. If Yes, value = 2 and if No, value = 1.

I have a fourth customer number field named Total Risk Score.

Using Automation, I want the Total Risk Score to equal the values from the first 3 custom fields.

Tim Kopperud

Hi @Fernando Garcia, welcome to the Atlassian Community. You can use variables and smart values for this.

Set 1 or 2 into a variable based on Yes or No, like this

Create one variable for each.

PII

{{#if(equals(issue.PII, "Yes"))}}2{{/}}{{#if(equals(issue.PII, "No"))}}1{{/}}

PCI

{{#if(equals(issue.PCI, "Yes"))}}2{{/}}{{#if(equals(issue.PCI, "No"))}}1{{/}}

PFI

{{#if(equals(issue.PFI, "Yes"))}}2{{/}}{{#if(equals(issue.PFI, "No"))}}1{{/}}

Then you can use math expression to calculate, like this example

{{#=}} {{varPII}} + {{varPCI}} + {{varPFI}} {{/}}

This will sumarize the three variables. 

I'm not fully sure if you mean "sum" or something else when you say "...Total Risk Score to equal the values", but I used sum in this example. 

The rule might look something like this

I have used the Summary field in my example (see yellow marking), so you should replace this with your field Total Risk Score. Also use a Rule trigger and add a filter based on your specific need.

TimK.