How to use .round in an automation that is also a calculation

Genevieve_Green

I have created an automation to work out the average of 3 numerical fields.

 

Action is to update an "Outcome" field using the below formula:

{{#=}}{{issue.customfield_10679.asnumber.plus(issue.customfield_10680.asnumber.plus(issue.customfield_10681.asnumber))}} / 3 {{/}}

 

All 3 custom fields are Smalltext fields which default to 0 and are for us to enter a number 0-100 (how successful that criteria was).

 

The goal is this automation to to update the Outcome field with the output of that calculation, whenever Fields 1, 2 or 3 are edited.

 

eg. field 1 contains 25, field 2 contains 50 and field 3 contains 75.

the Outcome field should output 50, and does so correctly.

 

My issue is when the output is a decimal and returns very long, messy numbers.

 

I have seen the .round smart value but cannot seem to get it to work with my formula.

 

Could someone please advise how my formula should look to round the output down to the next whole number, or even to 1DP?

Walter Buggenhout

Hi @Genevieve_Green,

I don't have a working environment where I can test, but given the complexity of your formula I suspect the best way to try and achieve what you're after may be through a ROUND() function.

Something like this:

ROUND(
{{#=}}{{issue.customfield_10679.asnumber.plus(issue.customfield_10680.asnumber.plus(issue.customfield_10681.asnumber))}} / 3 {{/}}
, 0)

That function is listed on the smart values, math expressions overview page and may even let you define the number of decimals to display.

Hope this helps!