3 Decimal round off in qlik sense

[Rajkumar]

Dear all,

How to round off 3 decimal?

Round(Value,0.001) is not working ?

Please help

[Vegar]

Round()  should work. Make sure that your Value is intepreted as a numeric and not a string. 

[Rajkumar]

Eg: Round(0.999,0.001).

It returning 0.1 not 0.100 ?

[Vegar]

If it's only the presentation that is important then you can format your presentation as a num with three decimals, no need for round ().

Num(Value, '0.000')