My google sheet has just basic numbers (sometimes ONE decimal) and a calculation column.

So the calculation column should never have more than one decimal

But the DATA sheet (and the app) take it out a BUNCH of decimal places.

My google sheet has just basic numbers (sometimes ONE decimal) and a calculation column.

So the calculation column should never have more than one decimal

But the DATA sheet (and the app) take it out a BUNCH of decimal places.

I’ve noticed that too and seen a couple of comments regarding that. I’m hoping the math column will eventually be expanded to include rounding functionality to a specified number of decimals.

2 Likes

What I do not understand is that there is NO reason for the extra decimal points. We are only entering something like the beginning mileage is 811.8 and ending mileage is 818.1 and the difference is something like 6.3000000000018

Where is that coming from?

I could understand if there were decimals that long, and I was trying to round them, but these are just added for no reason - not even mathematically correct??

1 Like

Formatting floating point numbers is hard. Right now we’re just using the platforms default code for doing that, which apparently doesn’t always do a great job. Sorry. We’ll get around to fixing it.

2 Likes

We can’t give you a timeline yet, sorry.

1 Like