12 Replies Latest reply: Oct 4, 2017 6:24 AM by Miguel Cunha RSS

    Sum Aggr with condition

    Miguel Cunha

      Hi guys,


      How can I use a condition on the following expression?


      SUM(AGGR(SUM(DISTINCT Points), TransID))



      the condition i want to apply is {$<[Date_ID.autoCalendar.Year]={'2016'}>}


      I tried like this:

      SUM({$<[Date_ID.autoCalendar.Year]={'2016'}>} AGGR(SUM(DISTINCT Points), TransID))

      but it didn't work.

      Can you help me?


      Thanks in advance,

      Miguel Cunha