Formula format not displaying correctly in email automation

[mlines]

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!

[Sho]

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

[BillH]

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