Why "Rounddown" result is not same with Excel spreadsheets?

[global]

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…

[ScottWorld]

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.

[global]

Thank you very much for your kindness!

I’ll adjust it by myself with hoping Airtable team to fix it;-)

[ScottWorld]

You’re welcome! Be sure to email them to alert them to this!

[Bill_French]

global:

I can’t understand why it doesn’t work the same.
And I’d like to fix it ASAP.

If it’s caused by the floating point bug, it’s not likely to be fixed soon.

[ScottWorld]

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.

[kuovonne]

I am unable to reproduce this. What happens if you delete the values and retype them?

[ScottWorld]

I’m able to reproduce this. See screenshots below.

[kuovonne]

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:

[ScottWorld]

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.