Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Atlassian Community about banner
4,301,310
Community Members
 
Community Events
165
Community Groups

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

Edited

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

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
Community showcase
Posted in Trello

Taco Tuesday: New years' resolutions with Trello

Congratulations to @Laura Holton , our latest winner of Taco Tuesday! And thanks to @Kristján Geir Mathiesen for sharing the picture of Taco having fun with his new friend  B...

2,409 views 28 42
Join discussion

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you