Avoiding circular reference in Custom Time Dimension List

Hi Guys, I am using a custom time dimension list in a module as shown below. I am getting circular reference error when I try to fetch the "Ending Backlog of previous Period" into the "Begining Backlog of Current period". Is there a way to solve this problem without using the Native Time Dimension / formulas ? "PS- I have allready tried importing the Ending Backlog value of previous period into the beginiing Total Backlog (current period) by setting up IMports from a staging module. Its not working as expected."

	PY Apr - FY16	PY May - FY16	PY Jun - FY16	PY Jul - FY16	Formulaes
UI:
Beginning Total Backlog	0	78000	1114874.82	1114874.82	Ending Backlog (Previous Period )
New Orders	78000	1036874.82	0	0
Total Adjustments	78000	1036874.82	0	0	New Order + Adjustments
Ending Backlog	78000	1114874.82	1114874.82	1114874.82	Beginning Backlog (Current Period) + Total Adjustments
Previous Period		PY Apr - FY16	PY May - FY16	PY Jun - FY16
Next Period	PY May - FY16	PY Jun - FY16	PY Jul - FY16	PY Aug - FY16

Accepted answers

emilydunn

Dhruv,

You will need to map each period in the custome time dimension to real time. Then, complete the calculations in the real time dimension and pull the results back to the custom time dimension. It is also worth mentioning that the native time dimension is needed to do these sorts of calculations.

Try the mapping and let me know how that works for you. Happy Anaplanning!

Emily

All comments

emilydunn

Quick Links

Can you help?

Unanswered questions

Sorting General List
Hi, I wonder if there's a way I can sort my general list alphabetically. The list is used as a drop down menu in a line item module and I want the drop down menu to be easy to navigate. I've already tried the Order List action. I already have a module with a text-formatted line item based on that list. But when I try to…
Predefaulting A Feild in ANAPLAN
Hello Anaplan Community, I have a special requirement from a customer and would appreciate your input. Let me explain the situation: We have a hierarchy with three levels: Level 1, Level 2, and Level 3. Screen 1: Creation of Level 1 Items On this screen, the user selects a team. Based on their selection, an action runs to…
Looking for Anaplan End-Users to take a short survey!
We are looking for Anaplan end-users to provide feedback on their experiences with the Excel add-in. Interested individuals will respond to this 5-minute survey to help us understand personal needs and behavior when using the add-in. The feedback provided by survey takers is essential to the roadmap of Anaplan's products.…