4 Replies Latest reply: Oct 30, 2014 10:55 AM by David Rodriguez RSS

    Max value in alternate state field

      Hello!!!

       

      What is the syntax to find the maximum value of a alternate state field?

       

      This is my original expression: Sum({<ID_ROLLING={$(=Max(ID_ROLLING))},YEAR=[Group PL 1]::YEAR, MONTH_SHORT_NAME=[Group PL 1]::MONTH_SHORT_NAME>}VALUE)

       

      But now I just need those whose [Group PL 1]::year is the maximum value. Something like this wrong expression: Sum({<ID_ROLLING={$(=Max(ID_ROLLING))},YEAR=[Group PL 1]::max(YEAR), MONTH_SHORT_NAME=[Group PL 1]::MONTH_SHORT_NAME>}VALUE)

       

      Regards.