add percentage

[soniasweety]

Hi all,

I have a column avg score with values like

AvgScore( in percentage)

76

60

55

80

45

based on this column I want to  get the new column    if  avg score is  <60%    fail else pass.

and I want to add % to  above column how to add...

[Taoufiq_Zarra · Accepted solution]

@soniasweety  if I understood correctly to add pourcentage you can use for example

Num(YOURAVGFORMULA,'#0%')

and for fail and pass you can for example use

if(YOURAVGFORMULA<60,'fail','pass')

[soniasweety]

Hi,
if I use this Num(YOURAVGFORMULA,'#0%') im getting result values is 4500% 5500% like that ..

[MayilVahanan · Accepted solution]

Hi @soniasweety 

Try like below

Num(YOURAVGFORMULA /100,'#0%')
and 

if(YOURAVGFORMULA<60,'fail','pass')
or if(YOURAVGFORMULA/100<0.60,'fail','pass')