2 Replies Latest reply: Dec 13, 2010 11:59 AM by Dominic Ayling RSS

    Max Aggr value regardless of selection in field!  Please Help!

    Dominic Ayling

      Hi All

      I have the following formula that gives me the period with the maximum value:

      [CODE]=max(aggr(Sum({$<[4AN - Level 4 Account Name] = {'Non Pay Costs'},Period={'*'}>} Actuals*LY1_Flag),Period))

      Problem is I want this to stay the same regardless of any selection in the Period field, I added the Period={'*'} to the set analysis in the hope that this would work but something with the aggr means it still only gives me the max of the current;y selected periods.

      Please can anyone advise a way to fix this or do it in another way?

      Thanks

      Dominic