0 Replies Latest reply: May 7, 2018 7:31 AM by Vivek Pangasa RSS

    Multiple Number formatting handling in KPI

    Vivek Pangasa

      Hi,

       

      I am trying to add a KPI which populates the value on the basis of the filter (A) selection. If any value from filter A is selected, then it should display metric in percentage (%) else, if no value is selected, then it should display the value as a whole number. Somehow, I am not able to implement num() function in this if condition.

       

      Expression:

       

      if(GetFieldSelections([A])>0,

            num(($(v_weeklyVol)/$(v_weeklykpigoal_td)),'#,##.0%'),

            $(v_weeklyVol))

       

      Any suggestions?