Summary Task Baseline

H

HCLIFF

We have coded Server Schedule Indicator to present a "?" if a schedule is not
baseline. However, when we baseline schedules the detail tasks end up with
green stoplight indicators (desired result), but the summary tasks still have
the "?" The only way to get the Summary Tasks to display a green stoplight
is for the PM to highlight all the detail tasks below the summary Task and
outdent them, then quickly indent them back to their original position. IS
this situation a result of the custom coding? Is there a fix?

IIf([Baseline Finish]=ProjDateValue("NA"),"No
baseline",IIf(ProjDateDiff([Baseline Finish],[Finish])>(0.2*[Duration]),"Late
by more than 20%",IIf(ProjDateDiff([Baseline
Finish],[Finish])<=(0.2*[Duration]) And ProjDateDiff([Baseline
Finish],[Finish])>0,"Late","On schedule")))
 
H

HCLIFF

If you are referring to the Calculation Tab under Options, yes it is set to
calculate inserted tasks like Summary tasks.

Jan De Messemaeker said:
Did you set calculation for summary rows to use the formula? I guess not.

--
Jan De Messemaeker
Microsoft Project Most Valuable Professional
+32 495 300 620
For availability check:
http://users.online.be/prom-ade/Calendar.pdf
HCLIFF said:
We have coded Server Schedule Indicator to present a "?" if a schedule is
not
baseline. However, when we baseline schedules the detail tasks end up
with
green stoplight indicators (desired result), but the summary tasks still
have
the "?" The only way to get the Summary Tasks to display a green
stoplight
is for the PM to highlight all the detail tasks below the summary Task and
outdent them, then quickly indent them back to their original position.
IS
this situation a result of the custom coding? Is there a fix?

IIf([Baseline Finish]=ProjDateValue("NA"),"No
baseline",IIf(ProjDateDiff([Baseline
Finish],[Finish])>(0.2*[Duration]),"Late
by more than 20%",IIf(ProjDateDiff([Baseline
Finish],[Finish])<=(0.2*[Duration]) And ProjDateDiff([Baseline
Finish],[Finish])>0,"Late","On schedule")))
Click to expand...
Click to expand...
 
H

HCLIFF

Thanks, I figured it out

Jan De Messemaeker said:
Did you set calculation for summary rows to use the formula? I guess not.

--
Jan De Messemaeker
Microsoft Project Most Valuable Professional
+32 495 300 620
For availability check:
http://users.online.be/prom-ade/Calendar.pdf
HCLIFF said:
We have coded Server Schedule Indicator to present a "?" if a schedule is
not
baseline. However, when we baseline schedules the detail tasks end up
with
green stoplight indicators (desired result), but the summary tasks still
have
the "?" The only way to get the Summary Tasks to display a green
stoplight
is for the PM to highlight all the detail tasks below the summary Task and
outdent them, then quickly indent them back to their original position.
IS
this situation a result of the custom coding? Is there a fix?

IIf([Baseline Finish]=ProjDateValue("NA"),"No
baseline",IIf(ProjDateDiff([Baseline
Finish],[Finish])>(0.2*[Duration]),"Late
by more than 20%",IIf(ProjDateDiff([Baseline
Finish],[Finish])<=(0.2*[Duration]) And ProjDateDiff([Baseline
Finish],[Finish])>0,"Late","On schedule")))
Click to expand...
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

MS Project. Real progress of the project, % complete 1
how to stop displaying field in project professional 2007 save dia 4
Graphical Indicators Not Valid Error 5
Use double quotes or single quotes in formulas? 1
Exactly why will this formula NOT import to enteprise from MSP 2007? 4
Why does the 2nd formula below not work correctly? 1
Enterprise Custom Field 11
Custom Task Progress Indicator does not work if baseline changes 1

Top