1 Reply Latest reply: Nov 1, 2017 1:21 PM by Shahbaz Khan Mohammed RSS

    Set analysis

    bhavani b

      Hi Everyone,


      Can any one please help me on below logic.


      I have taken the below logic in the KPI, its showing only maximum month related count.


      =Sum(if(Aggr(Max({$<MonthYear={'$(=$(vG.CurrentPeriod))'}>}[RAG ind]),[Metric Group],Metric)=2,1,0))

      But in another KPI i have to show all the months related count by including [Metric Group] = 'Entertainment' also need to avoid the {"'-'"}, in the Metric group.

      Please help me what changes i need to do on the above expression as per the requirement,

      Thanks in advance.

        • Re: Set analysis
          Shahbaz Khan Mohammed

          Not sure if the below expression would work?

          =Sum(if(Aggr([Metric Group]-={'-'}, [Metric Group] = {'Entertainment'}>}[RAG ind]),[Metric Group],Metric)=2,1,0))

          Neglecting '-' and including Entertainment plus not using Max of Months which would give all months, I guess so.