Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

Truncated zero - how to get it back?

Topic Labels: Formulas
1525 3
cancel
Showing results for 
Search instead for 
Did you mean: 
Nedra_Hines
6 - Interface Innovator
6 - Interface Innovator

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?

3 Replies 3

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:

@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!

AFTSSTEVE_0-1725521541627.png