Forum Discussion

Nicho247's avatar
Nicho247
Icon for Helper III rankHelper III
6 years ago
Solved

displayed table values are not matching source data

Hello -   Difficult problem to describe.   I have a SQL query which is returning some data. In the SQL query I have cast the column in question as a decimal(18,2). I have then pushed this into ex...
Need Help
  • lbendlin's avatar
    lbendlin
    6 years ago

    That's the way decimals work. apply formatting to it if you want to display only two significant digits.

Nicho247's avatar
Nicho247
Icon for Helper III rankHelper III
6 years ago

the screenshot is what is displayed visually. but if i copy/paste it from power bi...it is correct.

 

screenshot reads

-153548.0799999999999

actual value is

-153548.08

 

N

 

lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
6 years ago

That's the way decimals work. apply formatting to it if you want to display only two significant digits.