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!
Page 1 / 1
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.
Formula Field Reference - Overview | Airtable Support
INT() should work as well, for example
INT({Test Float}*10)/10 where "Test Float" would be replaced by your field. 12.345678 will become 12.3
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.
I already edited the formula to Round or Round Down, both won't work in the automated email.
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.