Discussion Board for collaboration related to QlikView App Development.
I am using NUM(expression,'#.0%') to get results like 78.4%.
But how do i make it whole number without decimal, i.e rounding.
I want 78.49 as 79% and 78.44 as 78%. Any ideas?
Thanks in advance
How is 78.49% = 79%? Why not 78%? Isn't the cut off 78.5%?
yeah..that is correct. 78.5 should convert to 79%. I was trying to get 2 decimal accuracy. But even 1 decimal would work
This seems to work for me
=Num(Round('78.49%', 0.01), '#.%')
Replace 78.49% with your field or expression