Circular Reference Issue

Monpero · 2023-06-11T14:36:31+00:00

There was an error rendering this rich post.

Hi Anaplan,

Is there a workaround on circular reference issue?. I'm doing a calculation on the Profit Line Item which is:

But am getting a circular reference when adding the VOD Cost line item in the formula. The VOD Cost line item references also the VOD Revenue line item, which I've screenshot below.

Is there a workaround to correct this issue?

Accepted answers

All comments

rishi8118

You can create a duplicate line item which can be used for calculations.

Kamlendra

Here Because you have to refer line item for same time period, so we can't use LAG,LEAD, OFFSET to overcome circular reference. So better approach will be to have another line item where VOD Revenue line item referred by VOD Cost, should change it reference to New VOD Revenue Line item, where the same data from VOD revenue can be imported to new VOD Revenue line item, so its like involving import Action step (Cons-which do makes it less dynamic) or you can have daisy chaining, where one line item refer another and that another refer other.. to bridge common gap.

Monpero

Thanks very much @rishi8118 and @Kamlendra your responses where really helpful.

Quick Links

Can you help?

Unanswered questions

How have you from-scratch built lot-level, geo-based Inventory Consumption?
We’re working on modeling inventory consumption at the lot level, accounting for shelf life considerations, since we need visibility into which lots may not consume—both for risk reporting and E&O analysis. Each item may have customers with different shelf life requirements. For example, item A may need 270 days for some…
How to bring Row data into Columns?
Hi, Can you help me, how can we get row data into columns using Unique ID? Per attached below first snapshot, I want to bring rountingOrder 4, RecipientName, Sent and Completed dates in 1 row as show in sanpshot 2. Do I need to create Hierarchy list and Map?
How to Design Simulation Planning in Anaplan with Multi-Level User Input and Step-by-Step Logging?
Hi Anaplan Community, I'm working on a simulation planning model where users need the flexibility to input pricing adjustments at any level of the product hierarchy, and I’d love your guidance on best practices. 📌 Scenario Overview: We have a 4-level product hierarchy: Brand Category Sub Category SKU (lowest level) The…