Maximum Value of a line item

[PrevContributor]

Can you please suggest a way to find out maximum value of a line item across time period?   So for example My module has 2 dimensions Partner Name and Time. I have to find ma bookings for that partner in last 24 months and use it further   For a partner named ABC what is Maximum Value(bookings) across years 2013 and 2012 where bookings line item is at monthly time scale. I have to use this maximum value for further calculation. but I am not able to get to max value.  Regards, Ankesh

[PrevContributor · Accepted solution]

One way to do this might be...[list=1]

Create a line item named 'Max Bookings to Date'

Ensure its Time Summary is set to 'Closing Balance'

Give this line item the formula... IF Bookings > PREVIOUS(Max Bookins to Date) THEN Bookings ELSE PREVIOUS(Max Bookins to Date) Now you can...[list=1]

Create a module with just the Partner dimension; no time

Put in it a line item 'Max Bookings'

Give it a formula Source Module.Max Bookings to Date[SELECT: Time.'All Periods']

[PrevContributor]

Thank you this solves my problem. I was making one mistake in my approach which was similar to what you have suggested. Thanks a lot!