How are you calculating or showing slippage in a complex project?

[SuzannaHathaway]

I am trying to use Baselines - but I am not seeing how I would show that a project has slipped a month from its start.  Does anyone have a process they are using to calculate slippage in a project or a series of projects?  Thanks in advance for any guidance you can provide!

Sue

[Sven-iX · Accepted solution]

One way is to "save" initial planned dates as "set-once" calculated fields, and then show slippage in a second calculated field. 

IF(ISBLANK({DE:myOrigPlannedCompletion})&&{status}="CUR", {plannedCompletionDate}, {DE:myOrigPlannedCompletion})

The above will set the field ONLY if it's still empty, and the status is CUR. 

You can then create a second calc field to show the DATEDIFF

[kautuk_sahni]

@SuzannaHathaway Just checking in — were you able to resolve your issue? We’d love to hear how things worked out. If the suggestions above helped, marking a response as correct can guide others with similar questions. And if you found another solution, feel free to share it — your insights could really benefit the community. Thanks again for being part of the conversation!