Add points from different fields

Question

Hello everyone!

I have 4 different fields and each of these fields has a weight, is it possible to calculate each field * its weight and add the results in a fifth field?

Example:

Field A, if the option is 1 it is 1*5, if the option is 2, it is 2*5
Field B, if the option is 1 it is 1*4, if the option is 2, it is 2*4
Field C, add (5+10) + (4+8) and show the total 27

Thanks a lot

Bill Sheboy · Answer

Hi @Carlos Barros -- Welcome to the Atlassian Community!

Adding to the suggestions from @John Funk and @Mikael Sandberg ...

There is no else conditional expression as you tried.  Here are the supported formats to do that: https://support.atlassian.com/cloud-automation/docs/jira-smart-values-conditional-logic/#if

For what you originally asked, please try John's suggestion to use a Lookup Table as that will be easier to maintain the mapping of field values to desired numbers:

https://support.atlassian.com/cloud-automation/docs/jira-automation-actions/#Create-lookup-table

Kind regards,
Bill

Carlos Barros_qpc7ug · Answer

Hi Mikael!

IF I sum two numbers works, but I need sum two var, and Jira returns the value null

Any Ideas?

Thanks?

Carlos Barros_qpc7ug · Answer

Hi John, thanks!

But didn't work.

I created the var varImportancia
{{#if(equals(issue.customfield_10106, "1 - Baixa"))}}1
{{else if(equals(issue.customfield_10106, "2 - Mediana"))}}2
{{else if(equals(issue.customfield_10106, "3 - Importante"))}}3
{{else if(equals(issue.customfield_10106, "4 - Muito Importante"))}}4
{{else}}0{{/}}

and var varEsforco

{{#if(equals(issue.customfield_10107, "1 - 8 a 24 horas"))}}4
{{else if(equals(issue.customfield_10107, "2 - 25 a 80 horas"))}}3
{{else if(equals(issue.customfield_10107, "3 - 81 a 159 horas"))}}2
{{else if(equals(issue.customfield_10107, "4 - 160 a 240 horas"))}}1
{{else}}0{{/}}

and in the field Barros Field I inserted {{#=}} {{varImportancia}} + {{varEsforco}} {{/}}

When I change  two fields I receive Missing parameter(s) for operator +u: +

In Barros Field I put, for example {{issue.customfield_10107}} and i see the result 1 - 8 a 24 horas, but Jira dont convert 1 - 8 a 24 horas to 4

Any ideas?

Thanks