Extra Decimals When Displaying a Number in a String

[chrisharper]

I have a few currency fields that I am adding up in a simple formula field. I am then trying to display the output of that formula field within a text string I am building with another formula. However, I’m getting some strange decimals when showing the numbers.

In an effort to troubleshoot this, I create a new blank Airtable base for testing and I’m getting the same result. For no apparent reason (to me), when I reference the total field in the string, it will sometimes add a ton of decimal spaces, like this:

Here’s a link to my sample/testing base that is showing this issue: https://airtable.com/appqBYuTjL8QbhmF4/shrM4rk6GDRaJQ4QN

My formulas are pretty simple:

Total of Amounts 1 & 2: 

{Amount 1} + {Amount 2}

Display Total in a String: 

"The total of both amounts is $" & {Total of Amounts 1 & 2} & "."

I can’t figure out what might be causing this, especially when I manipulate the Amount 1 and Amount 2 values to reach the same sum, the decimals sometimes appear and sometimes don’t, such as in these examples:

Has anyone ever seen anything like this, and is there anything you suggest I do to my string formula to resolve it?

[Dimitris_Goudis · Accepted solution]

Hey @chrisharper, 

Please the sum in the ROUND formula with position 3, see my screenshots below: 

Thanks 

Dimitris Goudis

[chrisharper]

Thank you, @Dimitris_Goudis. Rounding seems to have solved the issue.

It still feels like unexpected behavior to me, as adding simple currency numbers with just two decimal places should display precise values and shouldn't need rounding. I also submitted this to Airtable Support in the event it might be a bug. 

[chrisharper]

UPDATE: Edgardo from Airtable Support responded to my ticket to say that the Airtable engineering team is investigating the issue. They don’t have a fix for it, but suggested @Dimitris_Goudis solution of using the ROUND() function as a workaround for now.