Referencing data from one time range to another time range

Hello All,

How can we reference data from a line item in a particular time scale to another line item with different time scale ?

Like i have my model calendar as FY 2016. And i have added a time range as FY 2017. Lets say i have a line item (x) whose time range is same as model calendar, and another line item (y) whose time range is FY 2017. How can we refer the data or extract the data (without importing) from x to y ?

Thanks,

Soumik Paul

Accepted answers

All comments

PaulRitner

Hi,

Where ranges overlap, you will be able to pull data 1:1 without any special formula references. For example, if your Model time range is set to fy2016, but also includes 2017 (as 1 future year), then to the extent that the two time ranges overlap you can pull data using anaplan's default behavior.

If you're asking how to pull 2017 data back into 2016 (or vice versa) then you'd have to calculate the period you are pulling in. For example, if you have a module using the 2017 Time Range and you want to pull 2016 (i.e. prior year) data in, then add a line item to calculate the prior year's Time Period and then use that calculated time period as part of the formula (i.e. LOOKUP: PriorYearPeriod) .... if PriorYearPeriod were the line item calculating the target 2016 period.

Paul

Quick Links

Can you help?

Unanswered questions

Importing from Data Hub: Incorrect or Missing Mappings in Target Model
When importing data from a Data Hub to another model, I'm seeing values in the target model that don't exist in the source. For example, seller assignments are being tagged with subregions that aren't present in the source data - some assignments are missing expected tags, while others are mapped to seemingly random…
ANAPLAN XL View
Hi, I need help in pulling a specific view in Anaplan XL. The first grid should display attributes of various projects, while the second grid should present the monthly financial data for these projects. Thanks in advance.
Add list members to a selective access list
Hi, I am working on a solution where the User should only have access to write/edit the list members that they add from an Action on the frontend. This action adds another list member to a selective access list. The problem is, in order to run the action, you need access to the entire list, so you would see all list…