1 Reply Latest reply: May 30, 2013 5:38 PM by mayilvahanan 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?