Rounding Numeric value does not work

[#1]

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.

[sreenivas]

Num(Value,'###.##')

[khadeer]

If u want to display in chart, go to number tab and there u can find different options. else u can use num function in backend. hope it will help.

regards,

Khadeer

[er_mohit]

use expression :num(#,##0.00) or if you want to do it in pivot chart then in seeting of chart go to number tab there you fixed decimal value 2 and then u ll see on right side a pattern came... so, in which pattern you want to see check there

hope it helps you.

[#5]

i used the function i the load script but i keep getting 247.47000000029 when I show the value in chart / list box.

I would it at least be 247.47000000000

Thanks.

[er_mohit]

use expression :num(#,##0.00) or if you want to do it in pivot chart then in seeting of chart go to number tab there you fixed decimal value 2 and then u ll see on right side a pattern came... so, in which pattern you want to see check there

hope it helps you.