calculate multiplication of 2 lists of customfields to Numeric customfield using Automation

thumuluru.shreya

I have 2 Customfields as Severity and Occurrence. These 2 customfields are dropdown fields. It Contains

Severity contains the dropdown values as(Negligible, Minor and Major). 

Occurrence contains the dropdown values as (Critical, Probable and Improbable)

Score is the numeric customfield to store the multiplication of both severity and occurrence

Ex:

Scenario 1:

If user selects

severity as Negligible (Internally it assumes as 1)

Occurrence as Probable (Internally it assumes as 2)

So in score the result will calculate as 1*2=2

Scenario 2:

If user selects

Severity as Major( Internally it assumes as 3)

Occurrence as Critical(Internally it assumes as 1)

So in score the result will calculate as 3*1= 3

Expected output:

We took 2 customfields as dropdown list and we are expecting the output as multiplication of both customfields as Numeric. And this numeric maltiplication calculation of both dropdown list will happen internally. Eralier we have severity and occurrence both as numeric but now both are changed as dropdown list.

 

Could you please help in this

 

 

Tomislav Tobijas

Hi @thumuluru.shreya ,

One way you could do this is by using Lookup table actions for 'mapping' select list options with specific (number) values.

For example, create two lookup tables for each select list field (one for Severity and one for Occurrence):

And then, assuming 'output' field is a number type field, you can use automation math expressions to calculate desired value:

In this example (as stated in your question), I've simply multiplied Severity * Occurrence values by using the following expression:

{{#=}}{{severity.get(issue.customfield_10367)}} * {{occurence.get(issue.customfield_10368)}}{{/}}

Of course, you can name those Lookup tables as you wish, and you need to use appropriate custom field IDs for Severity and Occurrence field that you're using.

Hope this helps.

Cheers,
Tobi