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...
QuickBaseCoachD's avatar
QuickBaseCoachD
Qrew Captain
8 years ago
Joey,
Quick Base does not make math errors. :)

You number which appears as 39.87 is actually about 39.865.  It only appears as 39.87 since you have it set to display to 2 decimals.

This is probably a calculated currency field.

You will need to round it before doing that Multiplication on presumably Qty.

Round( I assume that you already have a formula field, 0.01) 

Here is the help on Round, see their first example

https://login.quickbase.com/db/6ewwzuuj?a=dr&r=5&rl=dyz