Formula format not displaying correctly in email automation

Topic Labels: Automations Formulas
623 2
Showing results for 
Search instead for 
Did you mean: 
4 - Data Explorer
4 - Data Explorer

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!

2 Replies 2
11 - Venus
11 - Venus

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