stop light function

[schemr]

hi,
i am trying to create a stoplight function in MS Project and PWA. i have
created 2 colums in the Enterprise global template. one is called OverDue
Task in the Task field with a number type. this column has the following
formula: IIf([%Complete]<100 AND Now() > [Finish], 1, 0). when this formula
is applied to the project, all tasks follow the appropriate behavior
according to the formula. but i cannot get the Summary task to show RED if
ATLEAST ONE sub task is OVERDUE. the summary task also goes by this formula.
is there any way to get around this. FOr the webaccess, i have created a new
field in the project section with the number type. this has the formula:
IIf([Enterprise Number1] = 1, 1,0) meaning if the value of OVERDUE from the
task field is RED it shud show red. this also isnt functioning correctly.
please help

 

[Mike Glen]

Hi schemr,

Try posting on the server newsgroup. Please see FAQ Item: 24. Project
Newsgroups. FAQs, companion products and other useful Project information
can be seen at this web address: http://project.mvps.org/faqs.htm

Mike Glen
Project MVP

 

[Gérard Ducouret]

Hi Schemr,

<<get the Summary task to show RED if ATLEAST ONE sub task is OVERDUE.>>
Instead of a Number field, put your formula in a Flag field.
In this case, you'll have different options for Summaries and Group.
Instead of a formula, use "Report" (?French version, i don't have the
English one today) and select the OR operator.

Hope this helps,