Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
To Round to two decimal places, you would use Round(field, '0.01').
See page 393 of Book I in the Reference Manual.
To Round to two decimal places, you would use Round(field, '0.01').
See page 393 of Book I in the Reference Manual.