1 Reply Latest reply: May 30, 2013 5:38 PM by Mayil Vahanan Ramasamy RSS

    Trying to return value if another value is the maximum

      I was trying to do something like this:


      if(Aggr(max(ModifiedDate), UserId, ReportStatus)  ...but it's not working.


      In pure English, what I am trying to do is return a User's report status if their Modified Date is the latest.  Is something in my statement incorrect or am I approaching the problem incorrectly?