Find Highest value

AbhishekChatterjee14

How to find the highest value for the regions amongst the 3 months and show that highest value in module Test Case 2?

Tags

Modeling

Calculation Functions

Accepted answers

You can try this way to arrive at a solution

All comments

You can try this way to arrive at a solution

While your solution works, I wouldn't advise it because you are hardcoding to a certain time member. What happens when the model rolls to another year? The proper solution would be to use the MAX aggregation function if you have All Periods turned on under your Time settings or TIMESUM() with the aggregation method of MAX.

Rob

Quick Links

Can you help?

Unanswered questions

Access model data outside of assigned workspaces?
I'm using the Integration API 2.0 to list workspaces https://anaplan.docs.apiary.io/#ListUserWorkspaces /workspaces "Retrieves all workspaces a user has access to within the user's default tenant." I'm only assigned to 2 workspaces (which are the only ones visible in the UI also), but this endpoint is returning everything.…
Why are users losing connection to the Apps
When a workspace Administrator does a model to model migration and chooses not to take the model offline, does the system still close people out of the Apps?
App Hub
Would someone advise how to find the App hub. I am following the module directions but I do not see it on my end.