circular reference issue

drathod
drathod
in Integrations and extensibility

hi, 

 

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

Tagged:

Answers

  • drathod
    drathod

    drathod_1-1651722249550.png

     

  • ManjunathKN
    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
    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

Categories