Forum Discussion
Solved
Calculated column incorrect calculation
Hi guys, I'm facing a problem which I've never seen using Power BI and I have no idea why. The problem is that I have created a calculated column with a basic calculation like this: "Euros / ...
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.
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