Forum Discussion

ZintJoseph's avatar
ZintJoseph
Qrew Captain
8 years ago

Has anyone come upon rounding errors when doing math calculation and in particular to a cost being multiplied by a markup

I do not see this every time but it does happen on certain costs. In the example below you will see what is happening 4 x 39.87 and the result is 159.46....should be 159.48 2 x 117.03 and the re...
_anomDiebolt_'s avatar
_anomDiebolt_
Qrew Elite
8 years ago
>Quick Base does not make math errors. :)

I am pretty sure QuickBase can make rounding errors if the numbers are large enough or if you look at enough precision. 

> 0.1 + 0.2
> 0.30000000000000004
MCFNeil's avatar
MCFNeil
Qrew Captain
8 years ago
Quick Base actually makes rounding errors all the time.  They don't carry the entire value when you are using summary fields and different types of calculations.

You have to force your summary fields to carry more decimal points, and even your formula numeric values to carry more decimal points.