Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Guys, how do I make qlik only round when the value is above 0.60, for example 89.60 = 90% and 89.50 = 89%?
Dual(If(Number - Floor(Number) > 0.6, Ceil(Number), Floor(Number)), Number)
You might have to play around with factors of 10 a bit to get to the number of decimal places you want.
If it has decimal places 0.60, will it round up?