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