Circular Reference for rollforward calc

I have a circular reference issue that I have not previously seen. The screenshot below shows a relatively simple example of a roll forward calculation where balances are carried forward. The issue I am having is that I would like the 'Out' line item to be dependent on the 'In' line item and simply take data from the 'In' line item and post the negative of it to future periods. I've hard coded the formula to post it 10 periods in the future (days in my example) but if I instead reference any line item to use as the length I get a circular reference, even if the '10' in this example is not dim'd by anything. I get a circular reference issue when using Lag, Offset, Lead, and Profile.

Any thoughts would be appreciated.

Accepted answers

DavidSmith

@jczimbal

Not sure if this will work in your case, but have you tried the STRICT parameter on Lag. This ignores previous periods so the circularly is constrained

In my example, I have a no dimensioned module with the parameter in

https://help.anaplan.com/anapedia/Content/Calculation_Functions/All/LAG.html

Let me know if that works

David

All comments

andrewtye

I thought I had it by using a duplicate line item but suffered the circular reference error. Then I tried using a time period line item and lookup against it. Brick Wall.

Like you I don't understand why it works with a hard coded number but doesn't against a line item with the same hard-coded number.

Wonder if @DavidSmith or @rob_marshall might be able shed some light on the situation?

ChrisAHeathcote

Hi,
I have overcome circular references by always taking the data from the source. Try copying the formula from the line item, 'In' directly into the, 'Out' line item.
Alternatively, create a section in the module where you pull the source data and reference these line items in all subsequent calculations.

ChrisAHeathcote

On further reflection I think your issue is with line item, 'Ending,' specifically the reference to the 'Beginning,' line item.

Try deleting this formula to see if this resolves the circular reference.

If so, replace each element of the calculation with the formula from each of the respective line items.

DavidSmith

@jczimbal

Not sure if this will work in your case, but have you tried the STRICT parameter on Lag. This ignores previous periods so the circularly is constrained

In my example, I have a no dimensioned module with the parameter in

https://help.anaplan.com/anapedia/Content/Calculation_Functions/All/LAG.html

Let me know if that works

David

jczimbal

David - including the STRICT mode did the trick!

Many thanks and to others with their suggestions.

andrewtye

@DavidSmith - knocking it out of the park as always! #EverydayLearningDay

DavidSmith

"it never leaves you"

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…
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…
Exports with anaplan using informatica connector
I'm trying to execute an Action to export data with the use of a Mapping in Informatica. But it gives us null rows .If we export directly from Anaplan , the export file has all the rows filled. Both exports have same number of rows but in the informatica export the values appear as blank. This issue is with only some…