Project Center graphical indicators not displaying

[moe]

We have a project center view that lists overall project status using red,
yellow, green indicators. We've noticed that the cost status.
< 5% Overbudget = green
5.01%-10% Overbudget indicators = yellow

are not showing up graphically. We have republished and have run out of
other ideas. Any ideas?

 

[Jonathan Sofer [MVP]]

Are you on PS2007 or PS2003?

Have you verified that the graphical indicators show correctly when in
Project Professional when you include that column in the Gantt view?

Have you been republishing from Project Center or Project Professional.
There were some issues with graphical indicators showing when publishing
from Project Center.

Let us know,

Jonathan

 

[MK]

We are on PS2007.

Some of the indicators do show but not these:
< 5% Overbudget = green
5.01%-10% Overbudget indicators = yellow

but rather they show text only - we have looked at the Server Settings
Enterprise Custom Field Descriptions to view the calcs and graphical
indicator values/image for these two settings.

Again - only these two show up as text.

Ideas?

 

[Jonathan Sofer [MVP]]

One thing I noticed is that anything over 10% would not have a color.

What field are you looking at for the numerical value? How do you determine
the % over budget? And is the field showing whole numbers like 5 and 10 or
fractions like 0.05 or 0.10?

Another thing is, have you hit the F9 button to force a refresh in Project
Pro?

Jonathan

We are on PS2007.

Some of the indicators do show but not these:
< 5% Overbudget = green
5.01%-10% Overbudget indicators = yellow

but rather they show text only - we have looked at the Server Settings
Enterprise Custom Field Descriptions to view the calcs and graphical
indicator values/image for these two settings.

Again - only these two show up as text.

Ideas?

 

[MK]

Hi Jonathan,

You had asked what field - it is the cost status and this is the formula.

Switch(([Baseline Start]=ProjDateValue("NA")),"No BL",[Actual Cost]=0,"Not
Started",[Baseline Cost]>0 And abs([Cost Variance]/[Baseline Cost])<=0.05,"<
5% Overbudget",[Baseline Cost]>0 And abs([Cost Variance]/[Baseline
Cost])>0.05 And abs([Cost Variance]/[Baseline Cost])<=0.1,"5.01%-10%
Overbudget",[Baseline Cost]>0 And abs([Cost Variance]/[Baseline Cost])>0.1,">
10% Overbudget",True,"Underbudget")

The text (vs graphical indicators) is coming in at whole number such as 5 or
10.

I did refresh Project Pro - F9.

So...any ideas as to why this comes in on project center as text not
indicators?

Thanks for your continued help!

 

[Jonathan Sofer [MVP]]

Moe,

I made a few tweaks to your formula to get it to work on my end the way I
would expect it to:

Switch(
[Baseline Start]=ProjDateValue("NA")),"No BL",
[Actual Cost]=0,"Not Started",
[Baseline Cost]>0 And abs([Cost Variance]/[Baseline Cost])<=0.05,"< 5%
Overbudget",
[Baseline Cost]>0 And abs([Cost Variance]/[Baseline Cost])>0.05 And
abs([Cost Variance]/[Baseline Cost])<=0.1,"5.01%-10% Overbudget",
[Baseline Cost]>0 And abs([Cost Variance]/[Baseline Cost])>0.1,"> 10%
Overbudget",
True,"Underbudget")

The only possible text values this formula can yield is "No BL", "Not
Started", "<5 % Overbudget", "5.01%-10% Overbudget", "> 10% Overbudget", or
"Underbudget"

So when you say that the text is coming back as a whole number such as 5 or
10, that doesn't make sense to me.

Also, what are the conditions you have for your graphical indicators. If I
was working with the formula above, I would use the following graphical
conditions as an example:

equals < 5% Overbudget [Yellow Circle]
equals 5.01%-10% Overbudget [Yellow Circle]
equals > 10% Overbudget [Red Circle]
equals Underbudget [Green Circle]
equals No Started [White Circle]
equals No BL [Gray Flag]

Jonathan

Hi Jonathan,

You had asked what field - it is the cost status and this is the formula.

Switch(([Baseline Start]=ProjDateValue("NA")),"No BL",[Actual Cost]=0,"Not
Started",[Baseline Cost]>0 And abs([Cost Variance]/[Baseline
Cost])<=0.05,"<
5% Overbudget",[Baseline Cost]>0 And abs([Cost Variance]/[Baseline
Cost])>0.05 And abs([Cost Variance]/[Baseline Cost])<=0.1,"5.01%-10%
Overbudget",[Baseline Cost]>0 And abs([Cost Variance]/[Baseline
Cost])>0.1,">
10% Overbudget",True,"Underbudget")

The text (vs graphical indicators) is coming in at whole number such as 5
or
10.

I did refresh Project Pro - F9.

So...any ideas as to why this comes in on project center as text not
indicators?

Thanks for your continued help!