Help

Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here

Truncated zero - how to get it back?

Topic Labels: Formulas
239 2
cancel
Showing results for 
Search instead for 
Did you mean: 

Good afternoon! I’m working on gmail automation and inserting $ amount fields into the content of my message. I’m using the following formula and noticed that the trailing zero is missing for an amount: CONCATENATE(‘$’& ROUND({Daily Rental Fee},2))

Missing zero:
image

How can I get the zero to appear?

2 Replies 2

Hi @Nedra_Hines, that’s how Airtable behaves in these cases. You can use the following formula on your formula field to add a 0 if truncated:

IF(Formula, Formula & IF(FIND(".", Formula & "") = LEN(Formula & "") - 1, "0"))

(this has been part of an older thread and kudos to @Justin_Barrett for the solution! Missing zero in currency data)

Thank you so much!!! It worked!!! :clap: :clap: :clap: