Forum Discussion
- ChrisChrisQrew Assistant Captain
Hi,
Can you post your rounding formula?
- QuickBaseCoachDQrew CaptainJoey,
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 - ZintJosephQrew CaptainNo rounding formula to start with but just added this and ran a couple of the items in question though it and it seems to have fixed it.
Round([Unit Cost]*[MU],0.01) - ZintJosephQrew Captain....and naturally the customer is holding up payment because the numbers do not match...I have only run around 250 parts quotes and orders through this system and now they bring it up. Must be why we have bad debt and overdue collections...I am always the last to know but am at fault for this.....
- QuickBaseCoachDQrew CaptainWell randomly, they will have been equally over and under charged. :)
- ZintJosephQrew CaptainThat is a positive outlook....give a little....get a little
- _anomDiebolt_Qrew Elite>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- MCFNeilQrew CaptainQuick 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.
- QuickBaseCoachDQrew CaptainI�m an Engineer, but alas, in this era of post Harvey Weinstein it�s probably no longer appropriate to post a link to the joke. But when I was a student a few decades ago there was a joke with a punch line
�So? I�ll be close enough for all practical purposes.�
The punch line is googleable.