How to find the highest value for the regions amongst the 3 months and show that highest value in module Test Case 2?
You can try this way to arrive at a solution
@Kiran96
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
I'm working on a model with three versions: Actual (Actual version), Scenario: Prognose lopend jaar (current version), and Scenario: Budget volgend jaar. For one of the calculations, the Scenario: Prognose lopend jaar version needs to use a different current period than the Scenario: Budget volgend jaar. For this, I…
Does anyone have any documentation on the trade-offs of having 1 model for all components of planning (service revenue, product revenue, labour planning), vs multiple models 1 for each and a consolidation model to tie it all together?
A quick reminder of the Bulk Copy functionality. Bulk Copy allows you copy large volumes of data from one slice of a model to another in a single, optimised operation, instead of using formulas or imports. Use case: copy a version (RF1) into a prior year version (PY RF1) using a versions list to allow for year-on-year…
