Skip to Content
Jul 02, 2020 at 01:32 PM

Dynamic Forecast Layout - How can I specify time ranges for my versions?

343 Views Last edit Jul 08, 2020 at 12:07 PM 3 rev

Hello all,

In my table where I used the planning model I would like to display three versions: actual, forecast1 and forecast2 and be able to define the start date and end date for this two forecast versions. I used the following help as a starting point:

I have already set up properties in the model:

As far as I understood, in the past I should use the cross calculation + calculation input control + formula option to do it:

I guess at the moment the forecast layout should be used:

I would be more than grateful if somebody could help me with the following:

1) How should the formula FIND look like to be able to work on time ranges if I will use the cross calculation?

2) How should settings for a forecast layout look like if I will decide to do it in that way? I guess the formula would be the same as in the point 1) for forecast1 but what about the forecast2? I know that I can add additional versions, but I cannot really specified cut over date.

Thank in advance for helping me out.

Best regards,



1.jpg (34.8 kB)
2.jpg (49.3 kB)
3.jpg (38.5 kB)
4.jpg (11.6 kB)