Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

How do I set a number Custom Field to 2 decimal points?

Lee Nesbitt October 27, 2021

Help!

I have a custom field that works out the commission on another custom field, how do I set the calculation to 2 decimal points, like a currency format....

set custom field "OTA Commission" to "{{%Booking Total ZAR}} * 0.171"

In the example below I would like the final calculation to be 837.90 not 937.90000000000000000000000 until the cows come home :(

 

Screen Shot 2021-10-27 at 13.33.01.png

 

It is affecting my reporting:

 

Screen Shot 2021-10-27 at 16.32.01.png

 

1 answer

1 accepted

0 votes
Answer accepted
David Bakkers
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
October 27, 2021

Hello and Blue Skies @Lee Nesbitt

Unfortunately, Butler doesn't have any general rounding functions to round float / real numbers up to a specific decimal point.

Refer to this thread where the question has been asked before.

Suggest an answer

Log in or Sign up to answer
TAGS
AUG Leaders

Atlassian Community Events