How are you calculating or showing slippage in a complex project? | Community
Skip to main content
SuzannaHathaway
SuzannaHathaway
New Participant
June 26, 2025
Solved

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

  • June 26, 2025
  • 2 replies
  • 332 views

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

Best answer by Sven-iX

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

2 replies

kautuk_sahni
kautuk_sahni
Employee
July 29, 2025

@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!

Kautuk Sahni
Sven-iX
Sven-iXAccepted solution
New Participant
June 26, 2025

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

    Terms & ConditionsAccessibility statement

    Loading footer...