(1) In my airtable base I have a calculation that displays as a percentage with no decimal. Ex: 65%
(2) However when I select this field to display within an automation (for an email) it loses its formatting and displays 64.93506493506493%.
Why does it lose its formatting and how can I get the formatting to transfer to the automation?
Sometimes the formatting applied to a field only applies when displaying the field value in the user interface.
Nest your formula inside the
ROUND() function. It is documented in the formula field reference. Because you want to display the number as a percent, you would round to two decimal places.
Hello Kuovonne, thank you that worked! Weird thing was is I had retested the trigger prior and it did not. But what I accidentally did was retest the entire automation. And for some reason now it is pulling in the rounded number. That is what is changed when I retested the trigger differently.
Thank you for your help!