Maximum Value of a line item

Highlighted
Previous Contributor

Maximum Value of a line item

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

2 REPLIES 2
Highlighted
Previous Contributor

RE: Maximum Value of a line item

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']
  • Highlighted
    Previous Contributor

    RE: Maximum Value of a line item

    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!