Forum Discussion
Round function not rounding
I can't seem to reproduce the problem with hard values:
Table without roundingTable with rounding
I get the same results?
Kind regards
Djerro123
-------------------------------
If this answered your question, please mark it as the Solution. This also helps others to find what they are looking for.
Keep those thumbs up coming! 🙂
What are you doing to export the reports? You could check the Issues forum here:
https://community.powerbi.com/t5/Issues/idb-p/Issues
And if it is not there, then you could post it.
If you have Pro account you could try to open a support ticket. If you have a Pro account it is free. Go to https://support.powerbi.com. Scroll down and click "CREATE SUPPORT TICKET".
Thanks, I will post there.
I do have another question, perhaps I am doing something wrong. I have a table with a field that is rounded using the round function, and then another table that is just 1/2 of the sum of that field. If I leave the second table unrounded, it = half of the sum of the first table. If I put the round function on the second table, the amount is off by a few dollars. Any ideas?
Are you using SUM (ROUND ([column]) )? Because that would first ROUND it and then sum the Rounded numbers. The other way arround will sum the colum and then round the result. So if I have two value, 4.02, 5.49 and go with the SUM(ROUND()), it would be 4 + 5 = 9. If I go with ROUND(SUM()) it would be ROUND(4.02+5.49) = ROUND(9.51) = 10.
Kind regards
Djerro123
-------------------------------
If this answered your question, please mark it as the Solution. This also helps others to find what they are looking for.
Keep those thumbs up coming! 🙂
That is helpful and makes sense, but I don't think quite fixes the issue. I wasn't very specific in my initial question, so let me try to do a better job of describing what's going on. I'm actually not using a sum function, I just do not have the other fields that break the data into multiple lines like in the first table so it is presented in a summarized way. So for example:
Table 1 Account Number Amount acct 123 128,544.44 acct 345 200,000.00 acct 789 20,048.44 Table 2- not rounded Acount Number Half Amount act 000 =0.5*Amount Table 2- rounded Account Number Half Amount act 000 =round(0.5*Amount,2) The first one that is not rounded gives me the correct number, 174,296.44. The one that is rounded gives me a different number: 174,299.84
It might also be worth mentioning that Amount in the first table has the rounding formula in it as well.