- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Jun 30, 2023 12:36 AM
I want to send an automated email that includes a formula field/token (it is called "6-month historical average"), formatted to 0.1 decimal place (this formula calculates an avg of the numeric values in 6 other fields, all of which are to 0.1 decimal place).
Although the "6-month historical average" field is formatted to 0.1 decimal place, when I test the automation, this value always appears with a long string of decimal places e.g. instead of 4.6 it will show as 4.6248482367213....
Why is this happening? I want the historical average to show with only 0.1 decimal place.
Thanks for your advice!

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Jun 30, 2023 01:01 AM
The format is only for appearance, and internally it is such a long number.
If you want to modify the numbers, you need to process them with functions such as ROUND (UP/DOWN) or FLOOR in the formular field.
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Jun 30, 2023 06:41 AM
INT() should work as well, for example
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Jun 21, 2024 09:34 PM
I already edited the formula to Round or Round Down, both won't work in the automated email.
