1 Reply Latest reply: Oct 28, 2016 1:18 PM by Sunny Talwar RSS

    Formatting text vs number

    Hanan Aqilan

      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