Clarity PPM

Expected Duration ("Earned Schedule")

  • 1.  Expected Duration ("Earned Schedule")

    Posted 10-16-2018 06:11 PM

    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