IF MODULE A = CUSTOM CALENDAR & FY19 DATA,
MODULE B = MODEL CALENDAR of FY21,
then how can we get MODULE A DATA to Module B as FY21?
It's because your Target Calendar doesn't have source period in it. This means there is no one-line solution, but let me give you two alternative solutions (either 1 or 2 will do the work):
Please note that you might already have "Calc_2" in some time settings SYS module (if not, build it there), and can utilize it here and in the future in multiple modules.
Hi @M.Kierepka .
Please refer to the Screenshots below:
1. Module A: Timescale= Months, Time Range = Custom Calendar (Ref. Image MS Teams-1)
2. Module B: Timescale= Months, Time Range = Model Calendar (Ref. Image MS Teams)
3. System Module: Timescale= Months, Time Range = Model Calendar (Ref. Image MS Teams)
4. The error I got is Datatype mismatch along with the formula for lookup suggested by you.(Ref. Image MS Teams- 5)
Is there anything else we are missing out or going a wrong path??
It's just miscommunication - I thought "Custom Calendar" is some list you created with different time structure than default Anaplan Calendar. But your "Custom Calendar" is just Time Range - Anaplan shouldn't have problems with mapping values between them.
About solution: In target line item, put formula "LAG( Module A.Sales, 24, 0)"
Explanation: LAG allows you to bring values with offset in time. 24 is the number of months between source and target (I assume you want to always pick numbers from "current year minus two"). The third argument, 0, tells Anaplan what to do if it will try to get values outside the range.
More about LAG formula: https://help.anaplan.com/3064919f-964e-4b84-be56-15f0e127e371-LAG
Hi Sir,
The formula was applied but the Values did not come up & still showing as 0. Please refer below screenshot.
Hi @M.Kierepka
Thanks a lot sir. The Calc 2 method worked after implementing this line item in the SYS module & the Lookup formula returned the 2019 values.
Regards,
I am testing export actions using workflow but its not generating any file when I am running the workflow, but the same process is generating export file when ran from the Actions→Process section. Is their any issue with the workflow functionality? Also, If I want to generate a file after completion of workflow and pull…
Hello Anaplan Community, I am seeking guidance on the most effective ways to automatically upload flat files to Anaplan Data Orchestrator (ADO). Currently, our process involves loading flat files to an Anaplan Datahub using Anaplan APIs and custom Python scripting. With Anaplan Data Orchestrator's capabilities for data…
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…