Apex Code Development You need to sign in to do that
Don't have an account?
Kirsty 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
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
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.
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).