2 Replies Latest reply: Apr 20, 2016 8:34 AM by Sunny Talwar RSS

    Ignore selections aggr

    sigurd fjeld

      Hi

      I have a spesific KPI that requires an aggr to get the right result:

       

      sum({1< year = {'$(vYear)'}, SomeDimension= {1}>} numberSomething)

      /

      sum({1< year = {'$(vYear)'}>} aggr(

      if(year = $(vYear),

      numberSomething)

      ,numberSomething,Dimension1,Dimension2,Dimension3))

       

       

      But this wont ignore all selections the way i want.

      Do anyone have any idea how to do this?

        • Re: Ignore selections aggr
          Sunny Talwar

          May be this:

           

          Sum({1< year = {'$(vYear)'}, SomeDimension= {1}>} numberSomething)

          /

          Sum({1< year = {'$(vYear)'}>} Aggr(

          If(Only({1} year) = $(vYear), numberSomething), numberSomething,Dimension1,Dimension2,Dimension3))

           

          or

           

          Sum({1< year = {'$(vYear)'}, SomeDimension= {1}>} numberSomething)

          /

          Sum({1< year = {'$(vYear)'}>} Aggr(

          Only({1} If(year = $(vYear), numberSomething)), numberSomething,Dimension1,Dimension2,Dimension3))

           

          or

           

          Sum({1< year = {'$(vYear)'}, SomeDimension= {1}>} numberSomething)

          /

          Sum({1< year = {'$(vYear)'}>} Aggr(

          Only({1} If(Only({1} year) = $(vYear), numberSomething)), numberSomething,Dimension1,Dimension2,Dimension3))