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:


      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.