Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Atlassian Community about banner
4,359,822
Community Members
 
Community Events
168
Community Groups

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

Edited

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

1 answer

0 votes
John Funk Community Leader Aug 23, 2022

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. 

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 .

Suggest an answer

Log in or Sign up to answer
TAGS
Community showcase
Published in Jira Software

An update on Jira Software customer feedback – June 2022

Hello Atlassian Community! Feedback from customers like you has helped us shape and improve Jira Software. As Head of Product, Jira Software, I wanted to take this opportunity to share an update on...

4,959 views 18 31
Read article

Atlassian Community Events