This content has been marked as final. Show 5 replies
Let's just get to the point.
When I grabed numeric value from database to qlikview (e.g. 245.47),
qlikview didnt represent the numeric value as exactly 245.47, but instead 247.47000000029 (when i format it to 10 decimal places).
I am not sure why. how to get the data to show exactly 245.47 or 245.4700000000000.
i tried to use round function Round(value, 0.01) but i still have 247.47000000029.