Num function

[rdsuperlike]

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

[sunny_talwar]

How is 78.49% = 79%? Why not 78%? Isn't the cut off 78.5%?

[rdsuperlike]

yeah..that is correct. 78.5 should convert to 79%. I was trying to get 2 decimal accuracy. But even 1 decimal would work

[sunny_talwar]

This seems to work for me

=Num(Round('78.49%', 0.01), '#.%')

Replace 78.49% with your field or expression

[Neymar_Jr]

Hi Ria,

May be

if(wildmatch(NUM(expression,'#.00%'),'*.49%'),

Num(NUM(expression,'#.00%')+.0001,'##.0%'),

NUM(expression,'#.0%'))

Thanks,

RT