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}}{{/}}
Hi Devon - Welcome to the Atlassian Community!
Why are you using a lookupTable? Aren't all of these fields in the same issue?
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
I did check all the values, no spaces unfortunately. I will add logs, thank you!
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Found the culprit, not sure how to fix it. One of the values is displaying one value, but totaling as another value.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.