Calculate numerical value of multiple choice test field

David_Mason_hpwula

Hi,

 

I am trying to create a prioritisation score which is based off of 3 categories and then added together into a final score. 

 

I have three multiple choice fields. 

Each have a number of options like below

 

Business Drivers

1 - New Business

2 - Increase Revenue

3 - Enhance Efficency

 

Customer Drivers

1 - Build Relationship

2 - New Product

 

Escalation

5 - Escalated.

 

I would like to convert each option to it's numerical value, add each option together then add each field together to create a Total Priority value. 

 

I've attemped this multiple times with for each's and table look up's but I can't wrap my head around it. Any help appreciated!

Bill Sheboy

Hi @David_Mason -- Welcome to the Atlassian Community!

You describe trying Lookup Tables, and so I wonder if you are using an automation rule.

If so, context is important for automation rule questions.  Please post 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. Those will provide context for the community to offer ideas. Thanks!

 

Until we see those...

You note using "multiple choice fields".  Do you mean you are using:

• single-selection option fields, or
• multiple-selection option fields? (e.g., New Business and Increase Revenue are both selected)

If you are using multiple-selection, Lookup Tables cannot easily be used.  The reasons have to do with iterators and scoping.  Regardless of that...

You could use a list iterator, conditional logic, and a math expression to do this.  For example to get the score for your Business Drivers, that could be:

{{#=}}
  0{{#issue.Business Drivers}}
    {{#if(equals(value, "New Business"))}} + 1{{/}}
    {{#if(equals(value, "Increase Revenue"))}} + 3{{/}}
    {{#if(equals(value, "Enhance Efficiency"))}}+ 5{{/}}
  {{/}}
{{/}}

This expression works by iterating over the selected values in the field, comparing them to desired value to add a number, and summing them with a math expression, using a default of 0 at the front.

 

Before proceeding, please confirm you have the correct smart values (or custom field ids) for the fields.  Smart values are name, spacing, and case-sensitive, and when an incorrect one is used is is replaced with null, failing silently.  To find the correct smart values, please use this how-to article: https://support.atlassian.com/cloud-automation/docs/find-the-smart-value-for-a-field/

 

Kind regards,
Bill