Custom Calculation

[Devon Engen]

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.

{{#=}}{{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}}{{/}}

[John Funk]

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]

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]

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? 

[Tuncay Senturk _Snapbytes_]

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]

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

[Devon Engen]

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