Create & Use a Variable in a calculation for a Yes/No dropdown to equal 1.5 or 1

Question

I am driving myself mad trying to figure out my mistakes.

* I have two Yes / No fields:* issue.customfield_10414* For "Adoption"

* issue.customfield_10415 * For "Retention"

* I need to create a variable for both to equal 1.5 if YES or 1 if NO* With NO (1) being the default (if possible)

* I then need to multiply those variables value against another field* issue.customfield_10353

I simply cannot get the syntax right to return any value from the variable.

* One of the attempted variable definitions:* Name: Retention* {{#=}}( 0{{#if(equals(issue.customfield_10415,"Yes"))}}1.5{{/}}{{#if(equals(issue.customfield_10415,"No"))}}1{{/}} ) {{/}}

* One of the attempted formulae:  * {{#=}}{{issue.customfield_10353|0}} * {{issue.Retention}} * {{issue.Adoption}}{{/}}

I am certain the issue is with the variables, but I am cross-eyed at this point.

Help??

Bill Sheboy · Answer

Hi @JON C BYERS -- Welcome to the Atlassian Community!

Are your fields single-select, option fields?

If so, please use the value attribute to check them in the condition, and ensure the value exactly matches the case of your field options...or force them to a known case:

{{#if(equals(issue.customfield_10415.value.toLowerCase(), "yes"))}}1.5{{/}}

Can the fields be empty?  If so, ensure you add handling for that case (i.e., what number to use in place of null values).

Kind regards,
Bill

Trudy P Claspill · Answer

Hello @JON C BYERS

Welcome to the Atlassian community.

Can you provide screen images showing us your entire rule?

When you create a variable you give it a name. When you then want to use that variable later you do not preface it with issue. That prefix is used only when you want to reference a field in the issue. A variable is not a field in an issue.

Notice that it tells you here exactly how to reference the variable.

In addition you can use the Log action right after your Create Variable action to print into the rule execution log file the value of the variable to see if it was set the way you expect.

That will help diagnose if the syntax you're using to set the variable is correct. I haven't delved into that syntax yet to evaluate it.

Lastly, variables are always stored as Strings. You may need to cast it as a number when you want to use it in a calculation: {{Retention.asNumber}}