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:
How can I get the zero to appear?
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)
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!!! 
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)
@Rupert_Hoffsch1 Hmmm I have gone through this thread and the previous but still can't seem to get it to work.
I don't get any error with the formula or anything, just still rounds to two. Even in the preview results window in the formula. I have attached an image below, any help would be great
Thank you!
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.