function readOnly(count){ }
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
+ Start a Discussion
Kirsty BeyersKirsty Beyers 

Do formulas (set up to have 5 decimal places) always round off when being pulled through to a HTML template?

Hi all

On an Opportunity page, I have many formulas set to be 8 characters in lengh and 5 decimal places. When pulling these fields into a HTML email template, they round off. Example - 144.36860 becomes 144.369 on the email template.

Is there a way to prevent it automatically rounding off? It is essential I retain at least 4 decimal places for financial purposes.

It was suggested I create a text formula field - is that the only solution?

Thanks all
Prateek Singh SengarPrateek Singh Sengar
Hi Kirsty,
Email templates should not change the field behavior. Can you please share the formula you are using for rounding of the integers in the formula field.
Kirsty BeyersKirsty Beyers
Hi Prateek

My apologies - it is not a formula field, rather a number field type. The number options are set up as: 8 (or) 5 in length & 5 decimal places. The value is rounding off when being pulled through to a HTML template (as above).