How to sum 3 number field in one number field but number field value depend on other select lists

Question

Hello community

I have requirement Where I want to sum up 3 number field in one number field but these number field value is depended on another select list fields.

note : Number fields are not visible on screen it is just for assigning values to number fields on the basis Of select list fields.

Number1            Select list1

2                         Abc

3                         SHF

Number2.          Select list 2

4                         DHG

2                          DDS

Number3.          Select list 3

3                          HHF

6                          HIG

user will select option from select list 1 and select list 2 in issue creation and on the basis of selection Number1 and Number2 field will update and sum up in Number4 field.

when ticket goes in done status than user will select list 3 and on the basis of option number 3 field will update and at the end Number 4 field is sum of Number1, Number2, Number3

any thoughts

BR//

Vinay

Vinay_c3oxat · Answer

Hello John

The problem is all number field are not present on screen , i have created 3 separate rule for updating number field on the basis of select list with same IF/Then conditions.

Than another 4th rule, any changes to select list 1,2,3, than update number 4 =
{{#=}} {{issue.customfield_10233|0}} + {{issue.customfield_10234|0}} + {{issue.customfield_10235|0}} {{/}}

but it is updating as 0 value .

John Funk · Answer

Hi Vinay,

You should be able to do this with an Automation for Jira rule if I understand your use case correctly.

You would use a series of IF/THEN conditions to select the right fields for doing the sum.

Give it a try and post your rule here if you run into any problems.