2 Replies Latest reply: Dec 13, 2010 11:59 AM by 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

To ignore the selection on Period, add Period= with no Set Modifier to your Set Analysis.

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

EDIT: Since you have two aggregate functions, you may need to add Period= to your Max as well. I'm not sure, but if that one doesn't work, you may want to put your Set Analysis in the Max too.

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