Task Starting Late

[Jerry Yasir]

Hi All

Can any one tell me what is the formula to Calculate the tasks that are
Starting Late. I had tried the following formula but it is not
working. Existing formula or any guideline to create such formulas
will be highly appreciated.

Tasks Starting Late = IIf([% Work Complete]="0%" And [Start] >[Current
Date] And [Actual Start]=ProjDateValue("NA"),"St­arting Late","On
Schedule")

Thanks and Regards
Jerry

 

[Jan De Messemaeker]

Hi Jerry,

Whatever the formula, this will never tell you that the task is LATE.
It will only tell you the task hasn't started yet.
To verify a start is LATE you have to compare it to the baseline
HTH

--
Jan De Messemaeker
Microsoft Project Most Valuable Professional
http://users.online.be/prom-ade/
+32-495-300 620
"Jerry Yasir" <[email protected]> schreef in bericht
Hi All

Can any one tell me what is the formula to Calculate the tasks that are
Starting Late. I had tried the following formula but it is not
working. Existing formula or any guideline to create such formulas
will be highly appreciated.

Tasks Starting Late = IIf([% Work Complete]="0%" And [Start] >[Current
Date] And [Actual Start]=ProjDateValue("NA"),"St­arting Late","On
Schedule")

Thanks and Regards
Jerry