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

    aggr() condition in set analysis

    marco mosconi



      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?