Need to Multiply 3 Custom field values in another Custom Field

Akshith Kumar

Custom Field 1 - Impact

Not Applicable-0
Insignificant-1
Minor-2
Minor-3
Moderate-4
Moderate-5
Moderate-6
Major-7
Catastophic-8
Catastophic-9
Catastophic-10

Custom Field 2 - Likelihood

• Not Applicable-0
• Rare-1
• Unlikely-2
• Unlikely-3
• Possible-4
• Possible-5
• Likely-6
• Likely-7
• Certain-8
• Certain-9
• Certain-10

Custom Field 3 - Counter Measures

• Not Applicable-0
• Best in Class-1
• Strong-2
• Strong-3
• Average-4
• Average-5
• Average-6
• Weak-7
• Weak-8
• Weak-9
• None-10
  
  Custom field 4 - RPN
  
  So first three are single select list custom fields
  
  Custom Field 4 = Custom Field 1 * Custom Field 2 * Custom Field 3
  I.E RPN = Impact * Likelihood * Counter Measures
  
  Can someone help me to do this In Jira Data Center?

Tuncay Senturk _Snapbytes_

Hi @Akshith Kumar 

As of my understanding, these are single-select custom fields and you need to convert them into numbers based on their values: e.g. Catastophic-8 is equal to "8", then multiply all three fields and set it to a number field which is customfield4.

Is that what you want?