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

Accepted answers

All comments

Misbah

@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

Austinv

Hello,

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

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

Here is the blueprint for the forecast module

dipanchowdhury

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?

Austinv

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?

RyanD

Is anyone else unable to read the text in the images posted above? Zooming in does not help the issue. The picture is extremely low resolution.

Quick Links

Can you help?

Unanswered questions

Request for Workflow Design: End-User Report Finalization & Stakeholder Notification with Version Co
Hi everyone, I'm looking to design a workflow and would appreciate your input or guidance on how to set this up effectively in Anaplan. So, the goal is: Once end users complete their data input, they should be able to trigger a process that: Notifies stakeholders via email with a link to a report. The report includes: A…
Generating Failure Dump - even though no warnings/error in Actions
I've few actions in our Supply model which when run takes some time on the "generating failure dump" step at the end of the action even though the import is a full success without warning or errors. This is just a few seconds when run for a single action, however we have a process with 120 actions, and most of these…
OAUTH 2.0 vs Google Sheets Extension
Hi, My org is looking to explore leveraging Google Apps script to extract data out of Anaplan and update already built templates in Google Sheets. We use the Anaplan Extension currently but find it crashes often with the amount of tabs, data, etc. Has anyone used both Anaplan OAUTH 2.0 API and Goolge Apps Script to write…