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

How do I determine why Anaplan API login fails intermittently ?
Hello, My interface uses basic authentication to log in to Anaplan. The login process has been failing intermittently for about a week. How can I identify the root cause of these Anaplan API login failures? Username and password are correct. The account is not locked or expired. Thanks, Jorge Palma
Anaplan XL license issue
Hello , I recently started Anaplan XL course , added XL however not able to add license How to ad license
Error while uploading ADO screenshots
Hello Anaplan Community, I'm facing an issue while uploading ADO screenshots, crosschecked my file size and naming conventions they are correct as mentioned in the lesson. Anyone faced the same issue? Pls let me know how if any solution to this problem. Thank you.