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

    Formatting text vs number

      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