Formatting text vs number

[#1]

Hi Guys,

I have this KPI formula

(IF(count(if([0.CFP/HH] ='HH',1,0)) > 1 ,num(sum([19.Not affordable]),'#,##0%'), 'No Answer'))

Right now it shows 16 without percentage like "Num" function" has any effect, but when I place it outside the if, it works, I cannot do this because the answer might be "No answer" or number 12%

What is missing here to make it work the way I need.

Thanks, -Hanna

[sunny_talwar]

This little test seems to work for me

=If(1=1, Num(1, '#0%'), 'No Answer') -> 100%

=If(2=1, Num(1, '#0%'), 'No Answer') -> No Answer