4 Replies Latest reply: Feb 12, 2014 2:41 PM by Steve Zagzebski RSS

    Getting Max Year/Month within aggr

    Steve Zagzebski

      I have the following expression that works fine:

       

      sum(aggr(
      if(sum([Member Count])<1 and sum([Claim Amt])>0,
            sum([Claim Amt]),0),
                 [Year Month],[Member ID]))

       

      However I want the aggregation to only be performed on the Member ID and the MAX of the Year Month each Member ID, not for every Year Month.

       

      Any help is appreciated.

       

      Steve