stoplights for a single late task in PWA

[Naomi Nissen]

I've successfully created a stoplight function in MS Project that
shows if a single task of a certain kind is late, that information
rolls up to the "0" line, showing that the project itself is then
late. The formula is a Task field, number type: IIf([%Complete]<100
AND Now() >
[Finish], 1, 0). Then I created graphical indicators in non-summary
rows where: equals 0.00 red
is greater than 0.00 green. Thanks to various authors for helping
make this successful! However, I now want that single bit of
information - the project is late - to show up in PWA project center.
I can't insert that column into a PWA view because the project center
doesn't accept task columns. So I went back to enterprise global,
recreated the formula as a Project, number type, with odd results in
PWA project center; all I get are zeros, unless the project as nothing
in it, in which case I get a red light!

Thanks for any help.

Naomi

 

[Rod Gill]

Did you open the project in Project Professional then save and re-publish?
You will need to do that for all projects after you customise enterprise
fields. It is only publishing that pushes information thru to the PWA tables
in SQL Server.

--

Rod Gill
Project MVP

NEW!! Project VBA Book, for details visit: http://www.projectvbabook.com

 

[Naomi Nissen]

Did you open the project in Project Professional then save and re-publish?
You will need to do that for all projects after you customise enterprise
fields. It is only publishing that pushes information thru to the PWA tables
in SQL Server.

--

Rod Gill
Project MVP

NEW!! Project VBA Book, for details visit:http://www.projectvbabook.com

I've successfully created a stoplight function in MS Project that
shows if a single task of a certain kind is late, that information
rolls up to the "0" line, showing that the project itself is then
late. The formula is a Task field, number type: IIf([%Complete]<100
AND Now() >
[Finish], 1, 0). Then I created graphical indicators in non-summary
rows where: equals 0.00 red
is greater than 0.00 green. Thanks to various authors for helping
make this successful! However, I now want that single bit of
information - the project is late - to show up in PWA project center.
I can't insert that column into a PWA view because the project center
doesn't accept task columns. So I went back to enterprise global,
recreated the formula as a Project, number type, with odd results in
PWA project center; all I get are zeros, unless the project as nothing
in it, in which case I get a red light!

Thanks for any help.

Naomi- Hide quoted text -

- Show quoted text -

Yes! This worked. Thanks.