Add up values from different fields with multiple selection

[Daniel Pfeffer]

Hello Community

I am trying to create an automation to calculate the sum of different fields (see below) that have a multiple selection with a scale of 0 - 3. The scale is structured as follows in each field:

0 - No
1 - Partially
2 - Yes

Objective: The sum of the selected scales is calculated in a field, i.e. only the 1st digit of the scale is taken into account.

Question: Is such automation even possible and if so, how?

I would be very happy if someone from the community could help me.

Kind regards

Daniel

[Bill Sheboy · Accepted solution]

Hi @Daniel Pfeffer 

For the multiple-select option field you show, the values have a digit in the first character.  That could be extracted using the left() function.  And then the list of values could be joined together for including in a math expression.

For example:

{{#=}} 0{{issue.myCustomField.value.left(1).join(" + ")}} {{/}}

I added a default value of zero at the front in case no values are selected.  As one of your values is "0 - Nein" you may want to change that.

Kind regards,
Bill

[Daniel Pfeffer]

Hi @Bill Sheboy 

Many thanks for the tip. Unfortunately, I can't get this automation to work as I'm still new to Jira.

Can you also give me a tip on how to set up the automation workflow for this case? I have searched the forum, but unfortunately I have not found a comparable case.

It would help me a lot.
Best regards
Daniel

[Bill Sheboy]

After substituting in your field's smart value (or custom field ID) in the expression I provided, you may copy-and-paste that directly into the field as the sum.  To confirm the smart value (or custom field ID) for your field, please use this how-to article: https://support.atlassian.com/cloud-automation/docs/find-the-smart-value-for-a-field/

The rule you show is branching to the parent.  Are you trying to sum the fields from the trigger issue, the children of the parent, or something else?

[Daniel Pfeffer]

Hi @Bill Sheboy 

Thanks to your help, I have now been able to set up the automation. Thank you very much for your support.

Here is the solution to the problem: