
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Oct 10, 2022 05:53 AM
Hello everyone.
I’m love to use Airtable everymonth to publish invoice and user’s portal.
Well, I found a problem with “rounddown” calculate.
When I input the date like following, the result was not correct.
Price field = 147.70
Quantity field = 50
Subtotal field[ rounddown(Price * Quantity,0) ] = 7384.00
I checked with Excel spreadsheet, the result was 7385.00 !!!
And I also checked with calc app, the result was 7385 also.
I can’t understand why it doesn’t work the same.
And I’d like to fix it ASAP.
Please help me…

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Oct 10, 2022 06:27 AM
Looks like a major bug with Airtable.
I would report this as a bug to support@airtable.com, but I wouldn’t hold your breath on them fixing this. I have rarely — if ever — seen them fix any bugs I have ever reported to them in years.

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Oct 10, 2022 06:31 AM
Thank you very much for your kindness!
I’ll adjust it by myself with hoping Airtable team to fix it;-)

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Oct 10, 2022 06:46 AM
You’re welcome! Be sure to email them to alert them to this!

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Oct 10, 2022 10:47 AM
If it’s caused by the floating point bug, it’s not likely to be fixed soon.

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Oct 10, 2022 06:14 PM
But doesn’t the floating point bug only crop up when you’re dealing with decimals? In this case, everything ends in .0000000 all the way to infinity. There’s no 1 at the end.

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Oct 10, 2022 07:58 PM
I am unable to reproduce this. What happens if you delete the values and retype them?

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Oct 10, 2022 08:47 PM
I’m able to reproduce this. See screenshots below.

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Oct 10, 2022 09:47 PM
Now I can reproduce it.
I’m going to go with the floating-point issue that @Bill.French pointed out.
My solution is to put in some intermediate rounding:

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Oct 11, 2022 03:50 AM
How can it be a floating point bug if there are no floating points?
I’m assuming that this ROUNDDOWN bug also affects ROUNDUP as well.
