circular reference issue

drathod

hi,

I am facing the below circular reference issue. what can i do to calculate "carried interest"?

Accepted answers

All comments

drathod

ManjunathKN

Hi @drathod

I see the circular reference is happening on time dimension. you can mitigate the circular reference by using LAG, Lead with Strict or substitute optional selection in Anaplan.

Lag - https://help.anaplan.com/3064919f-964e-4b84-be56-15f0e127e371-LAG

Thanks,
Manjunath

ankit_cheeni

Hi,

It would be easier to follow if you also shared the formula you created. I am assuming the circular reference is due to time dimension (Excel calculated at a cell level whereas anaplan calculates at a line item (column/row) level. This restricts your usage of different date values from the same line item. Try using PREVIOUS function to remove any lookups you're using. Again, would appreciate if you share actual build SS. That would help us be more specific

Quick Links

Can you help?

Unanswered questions

Workaround for Formula & Closing Balance summary methods together in Polaris
Hello folks, Does anyone know how to work around the Polaris limitation of using the Formula or Ratio summary method alongside the Closing Balance within the same line item? I have a Business Unit list where the total (All BUs) must display the Corporate (1 of 20 leaf items under All BUs total) number of Unique Customers.…
AnaplanXL Difficulties
Has anyone found success using Anaplan XL with Polaris models in a shared drive with or without concurrent users? My team has experienced a variety of errors, login failures, etc. sometimes it works, sometimes it doesn't. We've been recommended to save and edit files locally, which helps but certainly with its limitations…
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.…