Skip to Content
0
Former Member
Jul 29, 2016 at 10:11 AM

Spreading the Forecast value down different Versions

63 Views

Hello Experts,

I have a report in the following format - please find attached diagram of the report format

Version Org Hierarchy Key Figures Oct-Forecast Nov-Forecast Dec-Forecast V1 H1 Order 100 200 300 H2 Order 100 200 300 V2 H1 Order 500 600 700 H2 Order 500 600 700 H3 Order 500 600 700 V3 H1 Order 100 500 900

Basically the data above is all Forecast Data, that has been entered by the Users - by means of an Input Form.

This is just an example, for us we have way more Org Hierarchies in our Input Form and there is a Version for each set of Hierarchies - Set (selected hierarchies).

We are running a Six Month Forecast and for that we have Six Versions- so for example if we have selected 2 Org Hierarchies for the Six Months to which we will need to Forecast; then we will have Six Versions for these Two Org Hierarchies.

Now the initial Forecast that the User does (in V1), at the start of the term, we will like it to be spread across the other Versions as well by means of a Copy Function, as shown in the Table above.

In the start of the Term, the Forecast will be done on the First Version; then the other Versions (V2 - V6) should take the values of V1 and its respective Cost Center in their (V2 - V6) respective rows.

Kindly advise if we have a Dynamic way to approach on this functionality.

Regards,

Sachin