For a given billing document, there is an invoice value of $42.90. In my query editor, this looks correct.
When I bring it into my report, it adds all these 9s when I put 15 decimal places in there, and I can see that my results based on this field become skewed - they are in fact calculating based on the $42.8999999999999 and not the $42.90.
I've tried rounding from the query editor, and rounding in the report, as shown. When I put the decimal places there I still get the wrong answer. I cannot use Fixed Demical, as all my calculations based on Net Billing break. It may seem like a small issue, but it has a huge impact on my calculations overall.
Is there any way to bring the data in "clean"?
Thank you,
Robert
hi, @Anonymous
I think the best way is use Fixed Demical, if you don't want this, please refer to this similar post:
https://community.powerbi.com/t5/Desktop/Display-up-to-two-decimal-but-not-by-rounding/td-p/387300
Best Regards,
Lin
Come together to explore latest innovations in code and application development—and gain insights from experts from around the world.
Put your data visualization and design skills to the test! This exciting challenge is happening now through May 31st!
User | Count |
---|---|
391 | |
104 | |
68 | |
55 | |
49 |
User | Count |
---|---|
376 | |
119 | |
80 | |
67 | |
54 |