Refer formula across modules with different time range

Hi,

I have two modules named A and B. In module A, my time range is FY17 & FY18. And in my module B, the time range is FY18 & FY19. The fiscal year in my model is Jan to Dec. Now I want to refer the data of FY17 from module A to FY18 of module B. I have tried with Lag, lead and offset. But all these have the restriction as 'The time range providing arguments to a line item must match the time range for the result line item;. When I use Previous function, it is working fine. But I am getting result only for Jan18 from Dec17 with previous function. My requirement here is that I need to get the old year complete data from module A of FY17 to Module B of FY18.

Can you please help me?

Accepted answers

VIGNESH.M

Hi,

Try this,

Step 1: Create a line item(Previous Year) in the Target Module and format it as Time Period.Month Format and Use the below formula

Step 2: Write the logic to pull data from Source to Target Mod, use the formula highlighted below

Note: Keep the previous year line item in a separate system mod.

Regards,

Vignesh M

All comments

VIGNESH.M

Hi,

Try this,

Step 1: Create a line item(Previous Year) in the Target Module and format it as Time Period.Month Format and Use the below formula

Step 2: Write the logic to pull data from Source to Target Mod, use the formula highlighted below

Note: Keep the previous year line item in a separate system mod.

Regards,

Vignesh M

DavidSmith

@VSekar

And just to add, in the Time Settings module, the simplest formula to calculate the previous year month is

ITEM(Time) - 12 in a line item formatted as Month

no need for any Text extractions and re-joins.

David

VSekar

Hi Vignesh & David,

Thank you for your reply. It was helpful and resolved my issue.

Quick Links

Can you help?

Unanswered questions

Batch Script
Hello team, I am logging into Anaplan through SSO. I would like to create a batch script to import a file into Anaplan. For the Spoke model, I would like to run an process via a batch script to import data from the Data Hub. Can anyone provide me script for both the condition.
import monthly data with months in columns
is there a way to import data with months in columns (usual excel table view)? I have to transform the data so there are rows to cover each period in the upload data form, but I am wondering if there is a better way to just import the data as is with the months in the columns. please let me know what you think. thank you,
Cloudworks Big Query Integration Fail
Hello, I am receiving an 'Anaplan Upload Failed' Status Description when testing my integration with a Big Query dataset. The integration imports data from BQ to our Anaplan model. No other details given in the error log. I suspect that Cloudworks is not even picking up the file but am not sure what we did wrong on the set…