Cost / Schedule Indicators

[mike]

Hello, I am looking for some assistance in creating Graphical
Indicators for both Cost and Schedule.

For both,
Yellow is 10% over basline cost and work
Red is over 10%

What I am having trouble with is constructing the formula, which is
not my strong suit. No sure what the SWITCH is used fo, etc. Here is
a formaula I found in the groups:

IIf([Baseline Start]=ProjDateValue("NA"),999999,[Work Variance]/
[Baseline Work])

in the values I had:
Is greater than .10 Red
Is Greater than 0 Yellow
Is less tha n or = to 0 Green

I had thais as aa project entity, not task. The reason is that I need
this field available for a preojct center view. When I added, I could
not see the schedule indicator. The Proejcts are baselined, and no
work tracked. I was expecting to see 3 green lights for the 3
projects.

Any help is appreciated

MC

 

[Dale Howard [MVP]]

Mike --

The formula looks good. If I read it correctly, here is what the formula
does:

1. The formula tests for the lack of a Baseline.
2. If the Project has not been baselined, the formula returns a value of
999999.
3. If the Project has been baselined, the formula divides Work Variance by
Baseline Work.

Am I right? In your list of Graphical Indicator critier, however, I believe
you are missing a line. You need to test for the 999999 value, indicating
that the project has not been baselined, and then select a Graphical
Indicator to display. I would recommend you set up your Graphical Indicator
criteria as follows:

Equals 999999 Clock face (or a
symbol of your choice)
Is greater than .10 Red
Is greater than 0 Yellow
Is less than or equal to 0 Green

To resolve your problem beyond this, you need to open each enterprise
project, press the F9 function key to recalculate the project (and calculate
a value in the new field), and then you must save and publish the project.
After doing this, you should now see Green stoplight indicators in your
Project Center view. Hope this helps.

 

[mike]

Mike --

The formula looks good.  If I read it correctly, here is what the formula
does:

1.  The formula tests for the lack of a Baseline.
2.  If the Project has not been baselined, the formula returns a value of
999999.
3.  If the Project has been baselined, the formula divides Work Variance by
Baseline Work.

Am I right?  In your list of Graphical Indicator critier, however, I believe
you are missing a line.  You need to test for the 999999 value, indicating
that the project has not been baselined, and then select a Graphical
Indicator to display.  I would recommend you set up your Graphical Indicator
criteria as follows:

Equals                              999999               Clock face (or a
symbol of your choice)
Is greater than                  .10                       Red
Is greater than                  0                         Yellow
Is less than or equal to      0                        Green

To resolve your problem beyond this, you need to open each enterprise
project, press the F9 function key to recalculate the project (and calculate
a value in the new field), and then you must save and publish the project..
After doing this, you should now see Green stoplight indicators in your
Project Center view.  Hope this helps.

Hello, I am looking for some assistance in creating Graphical
Indicators for both Cost and Schedule.

For both,
Yellow is 10% over basline cost and work
Red is over 10%

What I am having trouble with is constructing the formula, which is
not my strong suit.  No sure what the SWITCH is used fo, etc.  Hereis
a formaula I found in the groups:

IIf([Baseline Start]=ProjDateValue("NA"),999999,[Work Variance]/
[Baseline Work])

in the values I had:
Is greater than            .10           Red
Is Greater than             0            Yellow
Is less tha n or = to      0             Green

I had thais as aa project entity, not task.  The reason is that I need
this field available for a preojct center view.  When I added, I could
not see the schedule indicator.  The Proejcts are baselined, and no
work tracked.  I was expecting to see 3 green lights for the 3
projects.

Any help is appreciated

MC- Hide quoted text -

- Show quoted text -

Thanks Dale !

What exactly doe the Switch expression accomplish?

Mike

 

[Dale Howard [MVP]]

Mike --

The Switch function is an alternative to a nested IIf statement. Hope this
helps.

Mike --

The formula looks good. If I read it correctly, here is what the formula
does:

1. The formula tests for the lack of a Baseline.
2. If the Project has not been baselined, the formula returns a value of
999999.
3. If the Project has been baselined, the formula divides Work Variance by
Baseline Work.

Am I right? In your list of Graphical Indicator critier, however, I
believe
you are missing a line. You need to test for the 999999 value, indicating
that the project has not been baselined, and then select a Graphical
Indicator to display. I would recommend you set up your Graphical
Indicator
criteria as follows:

Equals 999999 Clock face (or a
symbol of your choice)
Is greater than .10 Red
Is greater than 0 Yellow
Is less than or equal to 0 Green

To resolve your problem beyond this, you need to open each enterprise
project, press the F9 function key to recalculate the project (and
calculate
a value in the new field), and then you must save and publish the project.
After doing this, you should now see Green stoplight indicators in your
Project Center view. Hope this helps.

Hello, I am looking for some assistance in creating Graphical
Indicators for both Cost and Schedule.

For both,
Yellow is 10% over basline cost and work
Red is over 10%

What I am having trouble with is constructing the formula, which is
not my strong suit. No sure what the SWITCH is used fo, etc. Here is
a formaula I found in the groups:

IIf([Baseline Start]=ProjDateValue("NA"),999999,[Work Variance]/
[Baseline Work])

in the values I had:
Is greater than .10 Red
Is Greater than 0 Yellow
Is less tha n or = to 0 Green

I had thais as aa project entity, not task. The reason is that I need
this field available for a preojct center view. When I added, I could
not see the schedule indicator. The Proejcts are baselined, and no
work tracked. I was expecting to see 3 green lights for the 3
projects.

Any help is appreciated

MC- Hide quoted text -

- Show quoted text -

Thanks Dale !

What exactly doe the Switch expression accomplish?

Mike