Forum Discussion
Nicho247
6 years agoHelper III
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...
- 6 years ago
That's the way decimals work. apply formatting to it if you want to display only two significant digits.
lbendlin
6 years agoSuper User
where exactly is the mismatch?
Nicho247
6 years agoHelper III
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
- lbendlin6 years agoSuper User
That's the way decimals work. apply formatting to it if you want to display only two significant digits.