Graphical Indicators issue in PS 2007

[SP]

I am attempting to setup Enterprise Custom Fields in PS 2007, displaying the
data with a graphical indicator based on a formula.

I'm using the formula from this blog:

http://www.pptspaces.com/msprojectreporterblog/Lists/Posts/Post.aspx?ID=39

I create the custom field easily enough in PWA. After a few reloads of
Project Professional, I am able to find the field in the Insert>Column list,
and add it to a new project.

The fields all calculate without difficulty.

The problem occurs when I add it to an existing project. I add the column
fine, but for some reason, values only report for some of the rows. Some
rows show no data at all - they are entirely blank. Others do. This occurss
randomly, both on rows with actuals and those without!

Also.... when I publish the project, PWA does not always show the
indicator....


Am I doing something wrong?

 

[Jonathan Sofer]

I would have to see the formula definition to begin to understand why it is
showing on some rows but not others. Make sure you force a re-calculate on
your project to see all the values calculated. You can do this easily by
hitting F9 when you have the project open in Project Professional. Also,
have you made sure to assign a graphical indicator to all possible values
that the formula can calculate?

When you say that you publish the project, do you do it from Project Pro or
PWA? If you try and publish a project in PWA, all graphical indicators will
be wiped out and only the underlying value will display. This is a known
bug when publishing via PWA in MSPS 2007.

Jonathan

 

[SP]

Hi Jonathan,

This is the formula, though it seems to occur no matter how simple I make it.

Switch(
[% Complete]=100,"Complete",
(([% Complete]<100) And ([Finish]<Date())),"Overdue",
(([Baseline Start]=ProjDateValue("NA")) Or ([Baseline
Finish]=ProjDateValue("NA"))),"No BL",
[Finish Variance]<=0,"Green",
[Finish Variance]<=(ProjDateDiff([Project Start],[Project
Finish])*0.1),"Yellow",
[Finish Variance]>(ProjDateDiff([Project Start],[Project Finish])*0.1),"Red"
)


The behaviour is actually in that I have activated tooltips, and when I
tooltip over a graphical indicator, the underlying value is presented. In
the blank fields, tooltip shows nothing.

I am inserting the enterprise field in Project Pro, and Saving/publishing
from Project Pro. Note that the project itself is already "active/published"

 

[Jonathan Sofer]

So this is a task level text field? Also, when you define the graphical
indicators, when you switch to "Non-Summary Rows" and for "Summary" and
"Project" rows, did you check the box "Inherit criteria from non-summary
rows" and "Inherit criteria from summary rows" respectively?

What happens when you disable the graphical indicators option temporarily,
do all the rows show values? For ones that do not show values, have you
verified that the conditions fall true for one of your switch statements?

Jonathan

Hi Jonathan,

This is the formula, though it seems to occur no matter how simple I make
it.

Switch(
[% Complete]=100,"Complete",
(([% Complete]<100) And ([Finish]<Date())),"Overdue",
(([Baseline Start]=ProjDateValue("NA")) Or ([Baseline
Finish]=ProjDateValue("NA"))),"No BL",
[Finish Variance]<=0,"Green",
[Finish Variance]<=(ProjDateDiff([Project Start],[Project
Finish])*0.1),"Yellow",
[Finish Variance]>(ProjDateDiff([Project Start],[Project
Finish])*0.1),"Red"
)


The behaviour is actually in that I have activated tooltips, and when I
tooltip over a graphical indicator, the underlying value is presented. In
the blank fields, tooltip shows nothing.

I am inserting the enterprise field in Project Pro, and Saving/publishing
from Project Pro. Note that the project itself is already
"active/published"

I would have to see the formula definition to begin to understand why it
is
showing on some rows but not others. Make sure you force a re-calculate
on
your project to see all the values calculated. You can do this easily by
hitting F9 when you have the project open in Project Professional. Also,
have you made sure to assign a graphical indicator to all possible values
that the formula can calculate?

When you say that you publish the project, do you do it from Project Pro
or
PWA? If you try and publish a project in PWA, all graphical indicators
will
be wiped out and only the underlying value will display. This is a known
bug when publishing via PWA in MSPS 2007.

Jonathan