Stoplight not work in Project 2007

[Luis Mata]

Hi

I try to work in Project 2007, to create a StopLight based in the next
article...

http://www.projectserverexperts.com/Shared Documents/CreateStoplightIndicators.htm

Yet I create the Custom Field in PWA, the Tables and the View for show this,
but the problem is that the column with the Stoplight not Work, only show the
first status, but when I review the value for the colum and this change when
I Change for example the Fied Actual Finish...

I need your help...

Thanks...

 

[Marc Soester]

Hi Luis,

The article fromt he Project experts you are refering to is for Project
Server 2003. If you want to do this in 2007, it works a little different. If
you tell me what you want to achieve and let me know if you like to display
the traffic lights in Project Web Access, I am happy to look at it.

Marc

 

[Luis Mata]

Hi Marc

In this moment. I only try to repeat the Indicator only for review and
understand al about this new process with the Fields and Graphical
Indicators... I in this moment only I Try to create one Slippage Indicator
for Start and Finish Variance with the funtion [Start Variance] and [Finish
Variance]

I repeat the pass article only with part of this, I only try to resolve this
with the new process trought PWA. I Have one View with this Field, and show
the Stoplight but not Change the Graphic when the Value change

is greater than or equal to 5 days Color RED
is greater than or equal to 3 days Color Yellow
is greater than or equal to 0 days Color GREEN
is less than 0 days Color GREEN with Happy Face

All time show Color RED, and the ToolTIP show the Variance...but not work...

 

[Marc Soester]

Hi Luis,

You will have to go into PWA ( 2007) go to server settings > Customise
Custom fields > Choose a Project Text field and try the following:

IIf([Baseline Finish]=ProjDateValue("NA")," No Baseline",IIf([Start
Vaiance]<=0,"green",IIf([Start Vaiance]>5,"Red","Yellow")))

Then choose Graphical indicator and choose
fill in the fields ( e.g. equal , No Baseline, Grey traffic light etc)
Save the new field, republish your projects.This should do the job.
Let me know if it worked

--
Marc Soester
State Manager: EPM
http://marcsoester.blogspot.com

Hi Marc

In this moment. I only try to repeat the Indicator only for review and
understand al about this new process with the Fields and Graphical
Indicators... I in this moment only I Try to create one Slippage Indicator
for Start and Finish Variance with the funtion [Start Variance] and [Finish
Variance]

I repeat the pass article only with part of this, I only try to resolve this
with the new process trought PWA. I Have one View with this Field, and show
the Stoplight but not Change the Graphic when the Value change

is greater than or equal to 5 days Color RED
is greater than or equal to 3 days Color Yellow
is greater than or equal to 0 days Color GREEN
is less than 0 days Color GREEN with Happy Face

All time show Color RED, and the ToolTIP show the Variance...but not work...

Hi Luis,

The article fromt he Project experts you are refering to is for Project
Server 2003. If you want to do this in 2007, it works a little different. If
you tell me what you want to achieve and let me know if you like to display
the traffic lights in Project Web Access, I am happy to look at it.

Marc

 

[Luis Mata]

Hi Marc

I try with your code but when I test to open the project the Column with the
indicator no Show nothing...

And I Edit the Custom Field Again and appear this Message:
"The formula contains a syntax error or contains a reference to an
unrecognized field or function name."

And the formula show like this:
"IIf([MSPJ188743724]=ProjDateValue("NA");"No
Baseline";IIf([MSPJ188743725]<=0;"Green";IIf([MSPJ188743725]>5;"Red";"Yellow")))"

Thank's

Hi Luis,

You will have to go into PWA ( 2007) go to server settings > Customise
Custom fields > Choose a Project Text field and try the following:

IIf([Baseline Finish]=ProjDateValue("NA")," No Baseline",IIf([Start
Vaiance]<=0,"green",IIf([Start Vaiance]>5,"Red","Yellow")))

Then choose Graphical indicator and choose
fill in the fields ( e.g. equal , No Baseline, Grey traffic light etc)
Save the new field, republish your projects.This should do the job.
Let me know if it worked

--
Marc Soester
State Manager: EPM
http://marcsoester.blogspot.com

Hi Marc

In this moment. I only try to repeat the Indicator only for review and
understand al about this new process with the Fields and Graphical
Indicators... I in this moment only I Try to create one Slippage Indicator
for Start and Finish Variance with the funtion [Start Variance] and [Finish
Variance]

I repeat the pass article only with part of this, I only try to resolve this
with the new process trought PWA. I Have one View with this Field, and show
the Stoplight but not Change the Graphic when the Value change

is greater than or equal to 5 days Color RED
is greater than or equal to 3 days Color Yellow
is greater than or equal to 0 days Color GREEN
is less than 0 days Color GREEN with Happy Face

All time show Color RED, and the ToolTIP show the Variance...but not work...

Hi Luis,

The article fromt he Project experts you are refering to is for Project
Server 2003. If you want to do this in 2007, it works a little different. If
you tell me what you want to achieve and let me know if you like to display
the traffic lights in Project Web Access, I am happy to look at it.

Marc
--
Marc Soester
State Manager: EPM
http://marcsoester.blogspot.com


:

Hi

I try to work in Project 2007, to create a StopLight based in the next
article...

http://www.projectserverexperts.com/Shared Documents/CreateStoplightIndicators.htm

Yet I create the Custom Field in PWA, the Tables and the View for show this,
but the problem is that the column with the Stoplight not Work, only show the
first status, but when I review the value for the colum and this change when
I Change for example the Fied Actual Finish...

I need your help...

Thanks...