Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear all,
How to round off 3 decimal?
Round(Value,0.001) is not working ?
Please help
Round() should work. Make sure that your Value is intepreted as a numeric and not a string.
Eg: Round(0.999,0.001).
It returning 0.1 not 0.100 ?
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')