circular reference issue

Question

hi,

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

ankit_cheeni · Answer

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

ManjunathKN · Answer

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

drathod · Answer