Find Highest value
How to find the highest value for the regions amongst the 3 months and show that highest value in module Test Case 2?
Tagged:
0
Best Answer
-
You can try this way to arrive at a solution
0
Answers
-
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
2
