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.

Help with a basic "Sum" calculation error

Topic Labels: Formulas
1576 4
cancel
Showing results for 
Search instead for 
Did you mean: 
Trev_Chee
4 - Data Explorer
4 - Data Explorer

There seems to be an error in the SUM calculation of a list of my entries ( on multiple tabs also!). In the grid view, I click the “field name” to see the SUM of the added numbers but the total is always incorrect. I used a calculator to add the numbers up manuall and I get a differnet total.

It must be a simple error, but I have not been able to find the solution.

Please help because I’m trying to use Airtable for my business and these incorrect totals are causing a serious problem for my balance sheet.

4 Replies 4

We can’t really help without seeing the data.

How can I share this with you?

Thanks for your reply Kamille. I have sent you a message in your inbox. Should we should we continue the conversation there?

Yep - and my money is on the floating point error bug.