stoplight 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

schemr

 

[Ross Andren]

schemr,

For the first, when in the customize field dialogue, have you tried setting
the 'Calculation for task and group summary rows' to 'Rollup', and the
corresponding drop down to 'Sum'. The summary will then show the number of
tasks that meet the criteria of your formula, and your indicators can be '=
0' green and 'greater than 0' Red.

For the second, if you use the above concept, your number field will roll up
and show red if there is only one task in an entire project which is red. If
this is what you want, you can then set the formula for your Enterprise
Project Number field to equal the enterprise task field, and get your RAG
Status for the project to show through in PWA.

 

[schemr]

hi ross,
Thank you VERY Much for your prompt reply..really helpd me out...now it
worx perfectly. thanx again

schemr,

For the first, when in the customize field dialogue, have you tried setting
the 'Calculation for task and group summary rows' to 'Rollup', and the
corresponding drop down to 'Sum'. The summary will then show the number of
tasks that meet the criteria of your formula, and your indicators can be '=
0' green and 'greater than 0' Red.

For the second, if you use the above concept, your number field will roll up
and show red if there is only one task in an entire project which is red. If
this is what you want, you can then set the formula for your Enterprise
Project Number field to equal the enterprise task field, and get your RAG
Status for the project to show through in PWA.

--
Hope this Helps!

Ross Andren
http://www.pcubed.com

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

schemr