3 Replies Latest reply: May 23, 2012 11:30 AM by Jason Michaelides RSS

    Using Aggr(...), expressions, and max

      Hello, I am trying to use Aggr(....) and I'm having problems. This is how I understand it works.

      Max(
        { < Date = {"=Aggr(Date, @5)"} > }
         @5
       )
      

      This code will make a table out of Date and @5 and find the max value of @5. The thing is, I need @5 to be an expression. How can I extract the max of the second column in my table created by Aggr? It doesn't seem to work with just the expression in the place of all the @5's, should that work?