AnsweredAssumed Answered

Expected Duration ("Earned Schedule")

Question asked by gmurillo on Oct 16, 2018

Hello everyone,

 

I am using the duration based complete % method and create the next formula:

(Min(Max(DateDiff(baseline_start,Now(),"Day"),0),Max(1,DateDiff(baseline_start,baseline_finish,"Day")))/Max(1,DateDiff(baseline_start,baseline_finish,"Day")))*100

 

What I am looking for a way to compare the this actual %complete value with a planned complete % value (calculated based on the current date).


I need the formula to perform the calculation in a similar way than the complete % summed up on summary tasks and project level.

 

It is possible? thanks for your help

 

Best regards,

 

Gustavo

Outcomes