Rounding Function

[jagjivvt]

I am trying to round so that the total i get is in 2 decimal places. if i have 10.335, i need the number to be 10.34. when i apply the following in Qlik, round(1.335,02), the result is 10 and not 10.34 as it should be. any ideas on how this can work. thanks

[#2 · Accepted solution]

To Round to two decimal places, you would use Round(field, '0.01').

See page 393 of Book I in the Reference Manual.