Variable wont get calculated

Marcel Varsa_vp97ni

I have following command to calculate variable {{KMProgress}} as a percentage of count of done items divided by the total count of items: ({{KMDoneCount}}/({{KMTotalCount}})*100)

Both of the variables are {{lookupIssues.size|0}} of different JQL's - first returning 1 done item and second returning 10 items in total

When I run the automation and call {{KMProgress}} to be send by email this is the result I get: (1/(10)*100)

Can someone explain/help why it is not counting/returning that progress is 10% but instead returning a text?

Thanx

Bill Sheboy

Hi @Marcel Varsa 

For a question like this, please post an image of your complete automation rule, images of any relevant actions / conditions / branches, an image of the audit log details showing the rule execution, and explain what is not working as expected.  Those will provide context for the community to offer ideas.  Thanks!

Until we see those...

Created variables are text, not other types, like numbers.  To use a created variable in a math expression it usually must be converted with asNumber.  For example:

{{KMDoneCount.asNumber}}

What you saw was the text values concatenated together as they were not numbers.

 

Next, there are two formats for math expressions: inline and the longer format: https://support.atlassian.com/cloud-automation/docs/jira-smart-values-math-expressions/

What you plan to do with the result may help decide which format to use.  For example, the inline format of your formula could be this:

{{KMDoneCount.asNumber.divide(KMTotalCount.asNumber).multiply(100)}}

This will not handle empty fields / variables, but that should not be needed as you are using the default value of 0 with your lookup expression: {{lookupIssues.size|0}}

Additional tip: as you appear to trying to produce a percentage value, consider adding the asPercentage function or using floor or ceil (i.e., ceiling) to limit the result digits.

 

Kind regards,
Bill