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.
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