## Max value in a time dimension

Occasional Contributor

## Max value in a time dimension

Hello!

I'm trying to get the maximum value of the item test1 in the time range FY19-FY30 and then use that value in an operation in item2. Any idea?
In the example screenshot I attached, the maximum value of item 1 is 10 (FY30). In item2, I would like to do the operation 10*line item3.

Any suggestions to obtain the max value (10)????
Thanks!
Pablo

2 ACCEPTED SOLUTIONS

Accepted Solutions
Moderator

Try changing the summary to max and then in the Time Settings, turn on All Periods (this can also be done for time ranges).  Then use Line item[Select: Time.All Periods]

Community Boss

Hi @pabloSB ,

You can try below:

6 REPLIES 6
Moderator

Try changing the summary to max and then in the Time Settings, turn on All Periods (this can also be done for time ranges).  Then use Line item[Select: Time.All Periods]

Occasional Contributor

thanks for the response, super helpful! it works perfect!

Community Boss

Hi @pabloSB ,

You can try below:

Occasional Contributor

thanks for the response, super helpful! it works perfect!

Pablo

Super Contributor

Another thing you can try is to do a timesum with aggregation method set to MAX. This is slightly heavier than the other methods suggested but just wanted to put it on the table. You'd need to have a current period setup in time settings for this to work.

Moderator

Please do not use TimeSum() in a module dimensionalized by Time as it is a major performance hit.   Take a look at this video for more information about it:  https://www.youtube.com/watch?v=PvimWuX5jVw

@pabloSB A better solution that creates less calculations but gives you the same answer is to create a new module with a single line item named Total with the formula TimeSum('PV1 - Investor Returns,-99,99,MAX).  Now, a) the calculation is kicked off only once vs. the Select:time.All Time Periods was being kicked of for every month.

Hope this helps,

Rob

Function vs. Function: MOVINGSUM vs. TIMESUM We're back with round 2 of Function vs. Function! This time, join Anaplan Live! host Chris Weiss as he moderates a lively debate between Anaplan's own Rob Marshall and Mark Warren as they debate the best use cases for MOVINGSUM and TIMESUM. Choose your