14 Replies Latest reply: Feb 12, 2018 12:25 PM by ruti t RSS

    Issue with num function in if conditional

    ruti t

      Hi,

       

      I have the following measure in extension Simple KPI:

       

      if(GetFieldSelections([Type])='Percent',

      num(count(distinct APP_ID)/100,'#,##0%')

      ,num(count(distinct APP_ID),'#,##0')

      )

       

      I defined the number formatting as measure expression , but the percent doesn't work

      If i just write num(count(distinct APP_ID)/100,'#,##0%') - not in if conditional -  it works..


      Could you please advise?


      Thank you!

      Ruti