Copy data from one month of Current Year to all the months of Future Year

Highlighted
Occasional Contributor

Copy data from one month of Current Year to all the months of Future Year

Hi ,

 

i would like to copy the data from sept 2020 to jan2021 -dec,2021 for Budget version and take May,2021 data and copy to Jun,2021 -Dec, 2021 for forecast version. Any suggestions to achieve this.

Sept 2020    Jan 2021.....March  2021....Dec 2021

20     --              20               20                     20

 

Thanks

Sri Nitya

4 REPLIES 4
Highlighted
Master Anaplanner/Community Boss

Re: Copy data from one month of Current Year to all the months of Future Year

@SriNitya 

 

 

You need to create a logic for the number of months to be identified for each version. Once that is done you will have to push the numbers from the source month to the target months by Using PREVIOUS function and Finally you can import the numbers.

 

Misbah

Highlighted
Certified Master Anaplanner

Re: Copy data from one month of Current Year to all the months of Future Year

Hello, 

 

You can set up a System Module which sets the month you would like to allocate the values to 

Austinv_0-1604497175023.png

Once this is set up, it is a simple LOOKUP to get the values to a staging line item, which can be used as a source for an import action to prefill the values for the months shown

Austinv_2-1604497275478.png

Here is the blueprint for the forecast module

Austinv_3-1604497319634.png

 

 

 

Highlighted
Occasional Contributor

Re: Copy data from one month of Current Year to all the months of Future Year

Hello @Austinv 

Thank you so much for the reply. Sorry @SriNitya   is on leave and could not reply. We have tried this in our POC model and it has worked very well.

 

If you can help us with another step to automate this

 

Instead  of manually selecting which month will be used for budget/forecast for all 12 months, we would like to create a module and to select the month which will be used and it will get copied. any suggestions to achieve this?

Highlighted
Certified Master Anaplanner

Re: Copy data from one month of Current Year to all the months of Future Year

Apologies for the late reply. I need more clarification on the requirement before I can answer. Is the request that you want the selection of the months to be formula based so you do not need to manually set it?