5 Replies Latest reply: Dec 19, 2012 6:08 AM by Mohit Sharma RSS

    Rounding Numeric value does not work

      Hi all,

       

      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.

       

      Thanks.