4 Replies Latest reply: Feb 26, 2018 11:24 AM by Digvijay Singh RSS

    aggr() condition in set analysis

    marco mosconi

      Hi

       

      I am using aggr() function to calculate a condition a define a dimension:

       

      if(aggr (avg (COMPLETE), CDC_COMPL)=1,'ok','not ok')

       

      Now I need to sum(SALES) only for the CDC where the condition above is ok.

       

      for example I tried:

       

      sum({<CDC=(if(aggr (avg (COMPLETE), CDC_COMPL)=1,CDC_COMPL))>} SALES)

       

      however the sintax is returning an error,

       

      Can anyone suggest how this can be done?

       

       

      Thanks,

      Marco