Problem with Uploading Data (Extra Decimal Points for Percentages)

Known issue, Coda is using IEEE 754 for floating point math. This is pretty much the standard for all programming platforms and is native for processors. The problem is that only decimal parts that are 1/2, 1/4, 1/8, 1/16 etc (half of the previous one) or their sums (e.g. 0.75 as it’s 1/2 + 1/4) can be accurately represented in this encoding, while for 0.8 there’s no way to accurately store it as a sum of these fractions, hence these …000000002%.

The solution would be implementing some sort of decimal or fractional math, but it’s not an easy change, I believe.

The other thing is that if you need so many columns with percentages, perhaps you’re modelling your data wrong and not in the spirit of Coda? It might have made more sense to have these columns stored as separate rows?

1 Like