Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Round function not rounding

I have used the round function to round to 2 decimal places, but when I export my reports, the numbers are coming out almost rounded, but not quite (for example, 27,343.0900000001). Any idea why this...
  • JarroVGIT's avatar
    JarroVGIT
    6 years ago

    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! 🙂

JarroVGIT's avatar
JarroVGIT
Resident Rockstar
6 years ago

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! 🙂

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Thanks for taking a look, that makes me feel better-- I would expect to get the same results as well so I wonder if it's a bug related to the rounding issue in my original question. 

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    I am having the same problem. Regardless of how I implement the round function (I have tried every iteration), it seems to have issues. Some of my numbers round while others do not.  I believe this is a Power BI bug.