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

Accepted answers

rob_marshall

@pabloSB

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]

Akhtar.shahbaz

Hi @pabloSB ,

You can try below:

All comments

rob_marshall

@pabloSB

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]

Akhtar.shahbaz

Hi @pabloSB ,

You can try below:

ankit_cheeni

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.

rob_marshall

@ankit_cheeni

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

pabloSB

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

Pablo

pabloSB

@rob_marshall

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

Quick Links

Can you help?

Unanswered questions

Batch Script
Hello team, I am logging into Anaplan through SSO. I would like to create a batch script to import a file into Anaplan. For the Spoke model, I would like to run an process via a batch script to import data from the Data Hub. Can anyone provide me script for both the condition.
import monthly data with months in columns
is there a way to import data with months in columns (usual excel table view)? I have to transform the data so there are rows to cover each period in the upload data form, but I am wondering if there is a better way to just import the data as is with the months in the columns. please let me know what you think. thank you,
Cloudworks Big Query Integration Fail
Hello, I am receiving an 'Anaplan Upload Failed' Status Description when testing my integration with a Big Query dataset. The integration imports data from BQ to our Anaplan model. No other details given in the error log. I suspect that Cloudworks is not even picking up the file but am not sure what we did wrong on the set…