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

Echi's avatar
Echi
Regular Visitor
1 year ago

I discovered that the Table View> format> rounding  needed to be swiched from "auto" to the desired 2 digits.

this seems to hard lock to two digits in the viewed tables, and my csv's now export correctly.

(whereas rounding to 2 digits in Dax or Query kept generating the rounding artifacts.)