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

Lee Nesbitt

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

 

 

It is affecting my reporting:

 

 

unknown

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.