Skip to main content

Hi,

I have a currency column that is being auto-calculated, and the way Airtable is summing the numbers is sometimes incorrect - off by a few cents.

I suspect this is because the auto-calucations sometimes come from .00 or .000 fractional ownership of certain goods, so when Airtable sums a bunch of those at once it's somehow dropping or carrying over fractions of cents...

If I copy and paste the whole list of numbers in Excel, for instance, it gives me the correct total. So I'm searching for a way to somehow convert the auto-calculated field to a plain number field which will hopefully only give me the sum of the numbers as they are.

Any suggestions for how to to this? Thanks!

did you try modifying the number of decimal places in the formula formatting section?

Modifying the number of decimal places displayed only affects how the number is displayed, but the full decimal is used in any calculations. 

You can use ROUND() in your formula to round the numbers to your preferred number of decimals.

Modifying the number of decimal places displayed only affects how the number is displayed, but the full decimal is used in any calculations. 

You can use ROUND() in your formula to round the numbers to your preferred number of decimals.


That's what I was looking for - thanks!

 

Reply


Terms & Conditions