Forum Discussion
Calculated column incorrect calculation
Working with decimals can be funny in places. Sometimes a number will display as rounded but systems will often keep the "true" figure. An easy test might be to update your formula to something like
Round(Euros, 2) / Round(Weight, 2) / Round(Quantity, 2)
See if that changes the output any.
Is Quantity a rounded figure? For example is the real figure on the first line 0.025 but its displaying as 0.03?
It's rounded to two decimals, yes, but in this case, "original" number is 0.03.
In my knowledge, this shouldn't affect, just decimals, right?
Working with decimals can be funny in places. Sometimes a number will display as rounded but systems will often keep the "true" figure. An easy test might be to update your formula to something like
Round(Euros, 2) / Round(Weight, 2) / Round(Quantity, 2)
See if that changes the output any.That did the trick.
Thanks