Break Circular Reference
I'm trying to set up a project planning model in Anaplan.
As part of this setup, I'm trying to calculate the start date and end dates based on the dependencies.
The logic I'm trying to build is as below,
Start Date = IF ISBLANK(Dependent Step) THEN Project Start Date + Lead Time ELSE End Date(LOOKUP: Dependent Step) + Duration
End Date = Start Date + Duration
But, if you see above there is a circular reference between Start Date and End Date.
Can someone please help me to break this circular reference or suggest any alternative for this.
Attached SS for your reference.