Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

Custom Calculation

Devon Engen March 13, 2025

Hello - I'm back again! I have a few select list custom fields. I've built automation to assign a value to another custom field depending on the option selected. I have another custom field where I am trying to store the sum of those values. The below is what I have entered and it works except the calculation is off by 1 number. I cannot figure out where that is happening. I checked the automation where I assign the values and everything looks fine. I've attached a screen shot of one of those.

 

 

Screenshot 2025-03-13 145448.png

 

 

 

 

{{#=}}{{issue.LOE_Value}} + {{issue.Cost Impact_Value}} + {{issue.Business Process Impact_Value}} + {{issue.Resource Availability_Value}} + {{issue.Risk_Value}} + {{issue.Stakeholder Impact_Value}} + {{issue.Technology Impact_Value}}{{/}}

2 answers

0 votes
John Funk
Community Champion
March 13, 2025

Hi Devon - Welcome to the Atlassian Community!

Why are you using a lookupTable? Aren't all of these fields in the same issue? 

Devon Engen March 13, 2025

Because each filed had 2 drop down options so I needed a way for it to scan which option was selected and assign it the value. To be fair, this is my first time with automation in Jira

John Funk
Community Champion
March 14, 2025

You don't need to scan the options - there is a value in the field, just use it. 

What is the name of the field you are using the lookupIssues? 

0 votes
Tuncay Senturk _Snapbytes_
Community Champion
March 13, 2025

Hi @Devon Engen 

Have you checked all options already? Even a space (e.g., " 1") can cause to be misinterpreted as text. I'd suggest adding logs to see which values you are summing

Devon Engen March 13, 2025

I did check all the values, no spaces unfortunately. I will add logs, thank you!

Devon Engen March 13, 2025

Found the culprit, not sure how to fix it. One of the values is displaying one value, but totaling as another value. 

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
STANDARD
PERMISSIONS LEVEL
Product Admin
TAGS
AUG Leaders

Atlassian Community Events