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