Graphical Indicators Custom Field not displaying correctly

[L8rdays]

Hi, MSPS 2007 SP1 Infrastructure update

I have an Enterprise Custom field that has the following set:
Entity - Task
Type - Number
Forumla: IIf([Baseline Duration]=0,0,(-[Finish Variance]/[Baseline
Duration])*100)
Summary Rows - Use Formula
Assignment Rows - None
Values to display - Graphical
Green - is greater than or equal to (9.99)
Red is less than or equal to (20.00)
Yellow is less than or equal to (10.00)
Show data values in ToolTips is checked
Not a required field.

Where the problem is.
In project pro this field displays and works correctly.
In PWA the field calculates fine, but does not show the graphical indicator

It did when it was first created, I noticed about a week ago it wasn't
displaying the graphical indicator any longer.

Thoughts on why this may occur?

Thanks

 

[Gary L. Chefetz]

L8rdays:

Have you published using Pro? Prior to the Infrastructure update, server
side publishing would cause the graphical indicators not to display. You
should patch your system to this level and consider also deploying the
August and October Cumulative updates. By the way, I think your formula
could be improved. Testing for zero duration in a baseline will always
return true for milestones which should have a zero value even when a
baseline is set. So, this formula will not work for milestones.

--
----------
Gary L. Chefetz, MVP
MSProjectExperts
Project Server Consulting: http://www.msprojectexperts.com
Project Server Training: http://www.projectservertraining.com
Project Server FAQS: http://www.projectserverexperts.com
Project Server Help Blog: http://www.projectserverhelp.com

 

[L8rdays]

Hi Gary,

First THANKS for such a quick response.

This is a relatively new system and before any projects were put on it, the
SP1 and Infrastructure updates were completed. I am currently verifying the
August and October cumlative patches you are recommending, but when we looked
this morning we didn't see anything, so any specifics on this would be
appreciative.

Regards to my formula could be improved... Would love to hear your
suggestion for improvement how would you write it differently?

Thanks again!

L8rdays:

Have you published using Pro? Prior to the Infrastructure update, server
side publishing would cause the graphical indicators not to display. You
should patch your system to this level and consider also deploying the
August and October Cumulative updates. By the way, I think your formula
could be improved. Testing for zero duration in a baseline will always
return true for milestones which should have a zero value even when a
baseline is set. So, this formula will not work for milestones.

--
----------
Gary L. Chefetz, MVP
MSProjectExperts
Project Server Consulting: http://www.msprojectexperts.com
Project Server Training: http://www.projectservertraining.com
Project Server FAQS: http://www.projectserverexperts.com
Project Server Help Blog: http://www.projectserverhelp.com

Hi, MSPS 2007 SP1 Infrastructure update

I have an Enterprise Custom field that has the following set:
Entity - Task
Type - Number
Forumla: IIf([Baseline Duration]=0,0,(-[Finish Variance]/[Baseline
Duration])*100)
Summary Rows - Use Formula
Assignment Rows - None
Values to display - Graphical
Green - is greater than or equal to (9.99)
Red is less than or equal to (20.00)
Yellow is less than or equal to (10.00)
Show data values in ToolTips is checked
Not a required field.

Where the problem is.
In project pro this field displays and works correctly.
In PWA the field calculates fine, but does not show the graphical
indicator

It did when it was first created, I noticed about a week ago it wasn't
displaying the graphical indicator any longer.

Thoughts on why this may occur?

Thanks

 

[L8rdays]

Gary,

The October MS Project Pro hotfix corrected the problem thanks for the
direction. I still am confused why it was working and what broke it that
this hotfix all of a sudden fixed it.

We did not have to apply the server fix.

Thanks again!

 

[L8rdays]

Hi Again,

This hotfix fixed my graphical icon display issue on my development box, but
does not fix it on my production server. I have cleared out cached. I
would appreciate any insight and direction.

Thanks!

Gary,

The October MS Project Pro hotfix corrected the problem thanks for the
direction. I still am confused why it was working and what broke it that
this hotfix all of a sudden fixed it.

We did not have to apply the server fix.

Thanks again!

Hi, MSPS 2007 SP1 Infrastructure update

I have an Enterprise Custom field that has the following set:
Entity - Task
Type - Number
Forumla: IIf([Baseline Duration]=0,0,(-[Finish Variance]/[Baseline
Duration])*100)
Summary Rows - Use Formula
Assignment Rows - None
Values to display - Graphical
Green - is greater than or equal to (9.99)
Red is less than or equal to (20.00)
Yellow is less than or equal to (10.00)
Show data values in ToolTips is checked
Not a required field.

Where the problem is.
In project pro this field displays and works correctly.
In PWA the field calculates fine, but does not show the graphical indicator

It did when it was first created, I noticed about a week ago it wasn't
displaying the graphical indicator any longer.

Thoughts on why this may occur?

Thanks

 

[L8rdays]

Issue Resolved....

Reading through older logs I republished projects on my production server
and that resolved the final piece of the puzzle. This is a bug Microsoft
should fix.

Hi Again,

This hotfix fixed my graphical icon display issue on my development box, but
does not fix it on my production server. I have cleared out cached. I
would appreciate any insight and direction.

Thanks!

Gary,

The October MS Project Pro hotfix corrected the problem thanks for the
direction. I still am confused why it was working and what broke it that
this hotfix all of a sudden fixed it.

We did not have to apply the server fix.

Thanks again!

Hi, MSPS 2007 SP1 Infrastructure update

I have an Enterprise Custom field that has the following set:
Entity - Task
Type - Number
Forumla: IIf([Baseline Duration]=0,0,(-[Finish Variance]/[Baseline
Duration])*100)
Summary Rows - Use Formula
Assignment Rows - None
Values to display - Graphical
Green - is greater than or equal to (9.99)
Red is less than or equal to (20.00)
Yellow is less than or equal to (10.00)
Show data values in ToolTips is checked
Not a required field.

Where the problem is.
In project pro this field displays and works correctly.
In PWA the field calculates fine, but does not show the graphical indicator

It did when it was first created, I noticed about a week ago it wasn't
displaying the graphical indicator any longer.

Thoughts on why this may occur?

Thanks

 

[Gary L. Chefetz]

That part of it isn't a bug, it's just the way the system works.

--
----------
Gary L. Chefetz, MVP
MSProjectExperts
Project Server Consulting: http://www.msprojectexperts.com
Project Server Training: http://www.projectservertraining.com
Project Server FAQS: http://www.projectserverexperts.com
Project Server Help Blog: http://www.projectserverhelp.com

Issue Resolved....

Reading through older logs I republished projects on my production server
and that resolved the final piece of the puzzle. This is a bug Microsoft
should fix.

Hi Again,

This hotfix fixed my graphical icon display issue on my development box,
but
does not fix it on my production server. I have cleared out cached. I
would appreciate any insight and direction.

Thanks!

Gary,

The October MS Project Pro hotfix corrected the problem thanks for the
direction. I still am confused why it was working and what broke it
that
this hotfix all of a sudden fixed it.

We did not have to apply the server fix.

Thanks again!

:

Hi, MSPS 2007 SP1 Infrastructure update

I have an Enterprise Custom field that has the following set:
Entity - Task
Type - Number
Forumla: IIf([Baseline Duration]=0,0,(-[Finish Variance]/[Baseline
Duration])*100)
Summary Rows - Use Formula
Assignment Rows - None
Values to display - Graphical
Green - is greater than or equal to (9.99)
Red is less than or equal to (20.00)
Yellow is less than or equal to (10.00)
Show data values in ToolTips is checked
Not a required field.

Where the problem is.
In project pro this field displays and works correctly.
In PWA the field calculates fine, but does not show the graphical
indicator

It did when it was first created, I noticed about a week ago it
wasn't
displaying the graphical indicator any longer.

Thoughts on why this may occur?

Thanks