If a formula field (which is set to return a decimal value to 2 decimal places) is referenced in another formula field, it is not truncated to 2 decimal places. Instead, the whole decimal number is used.
For example:
and
When the original decimal formula field is used in UI, the correct number is returned (1.23). However, if that same decimal field is referenced in another formula, it is no longer truncated to 2 decimal places:
"Number of decimal places" applies to UI presentation. For calculations whole value is used, and I think this is correct. Use JavaScript built-in functions if you wish to use only 2 decimal places.
Hi Mike,
You can use a Template field instead of using another formula field to render the decimal formula with two places. Since template fields render client side you should be getting 2 decimal places as the result.
Piscoso, Martin
Rollbase
Ok, that makes sense. Thanks