Cost Indicator

[mike]

Hello, I recently received help on a schedule formula (Thanks Dale)
and I have a similar request for Cost.

I nedd to show green for when a proejct is tracking to its basline
cost
Yellow for when it is off its basline up to 10 % over
and Red when over 10%.


Here are my current selections:
Entity (Project - I need the indicators to show in Proejct Center. )
Type - Text

Formula:
IIf([Baseline Start]=ProjDateValue("NA"),999999,[Cost Variance]/
[Baseline Cost])

Values: Graphical Indicators:
Equals 999999 Clock Face
Is Greater than .10 Red
Is Greater than 0 Yellow
Is less than or = to 0 Green

After I applied this, I opened each proejct hit F9, Saved and
Pupulished. The Projects are baselined, and no work has been
completed. My Cost Indicator is Red, whereas I am expecting it to be
Green.

Thanks again for your help,

MC

 

[Dale Howard [MVP]]

Mike --

Well, something is defintitely wrong somewhere. Try the following:

1. Open each of your projects individually.
2. Click Tools - Options - View.
3. Select the "Show project summary task" option (if not already selected),
and then click the OK button.
4. Apply the Gantt chart view, if necessary.
5. Click View - Table - Cost.
5. Pull the split bar to the right and examine the Variance column for the
Project Summary Task (Task 0).

For the Project Summary Task, does the Variance column show $0.00? It
should. Let us know what you find.

 

[mike]

Mike --

Well, something is defintitely wrong somewhere.    Try the following:

1.  Open each of your projects individually.
2.  Click Tools - Options - View.
3.  Select the "Show project summary task" option (if not already selected),
and then click the OK button.
4.  Apply the Gantt chart view, if necessary.
5.  Click View - Table - Cost.
5.  Pull the split bar to the right and examine the Variance column forthe
Project Summary Task (Task 0).

For the Project Summary Task, does the Variance column show $0.00?  It
should.  Let us know what you find.

Hello, I recently received help on a schedule formula (Thanks Dale)
and I have a similar request for Cost.

I nedd to show green for when a proejct is tracking to its basline
cost
Yellow for when it is off its basline up to 10 % over
and Red when over 10%.

Here are my current selections:
Entity (Project - I need the indicators to show in Proejct Center. )
Type - Text

Formula:
IIf([Baseline Start]=ProjDateValue("NA"),999999,[Cost Variance]/
[Baseline Cost])

Values: Graphical Indicators:
Equals                        999999    Clock Face
Is Greater than                  .10        Red
Is Greater than                   0         Yellow
Is less than or = to            0          Green

After I applied this, I opened each proejct hit F9, Saved and
Pupulished.  The Projects are baselined, and no work has been
completed.  My Cost Indicator is Red, whereas I am expecting it to be
Green.

Thanks again for your help,

MC- Hide quoted text -

- Show quoted text -

Dale, thank you for the quick reply. I was in meetings from 10 till
now.

Looking at the project, in the client, with the summary task on, the
Cost Varience column displays $0.00 , which is correct, as no tracking
has been done as of yet.

Now nothing displays in the cost indicator field in the Proejct Center
view.
I did refresh thecalculation (F9) in the proejct, saved and pubished.

 

[Dale Howard [MVP]]

Mike --

Out of curiosity, what type of field did you set up for the formula and
Graphical Indicators? I have assumed you are using a Number field. Let us
know.

Mike --

Well, something is defintitely wrong somewhere. Try the following:

1. Open each of your projects individually.
2. Click Tools - Options - View.
3. Select the "Show project summary task" option (if not already
selected),
and then click the OK button.
4. Apply the Gantt chart view, if necessary.
5. Click View - Table - Cost.
5. Pull the split bar to the right and examine the Variance column for the
Project Summary Task (Task 0).

For the Project Summary Task, does the Variance column show $0.00? It
should. Let us know what you find.

Hello, I recently received help on a schedule formula (Thanks Dale)
and I have a similar request for Cost.

I nedd to show green for when a proejct is tracking to its basline
cost
Yellow for when it is off its basline up to 10 % over
and Red when over 10%.

Here are my current selections:
Entity (Project - I need the indicators to show in Proejct Center. )
Type - Text

Formula:
IIf([Baseline Start]=ProjDateValue("NA"),999999,[Cost Variance]/
[Baseline Cost])

Values: Graphical Indicators:
Equals 999999 Clock Face
Is Greater than .10 Red
Is Greater than 0 Yellow
Is less than or = to 0 Green

After I applied this, I opened each proejct hit F9, Saved and
Pupulished. The Projects are baselined, and no work has been
completed. My Cost Indicator is Red, whereas I am expecting it to be
Green.

Thanks again for your help,

MC- Hide quoted text -

- Show quoted text -

Dale, thank you for the quick reply. I was in meetings from 10 till
now.

Looking at the project, in the client, with the summary task on, the
Cost Varience column displays $0.00 , which is correct, as no tracking
has been done as of yet.

Now nothing displays in the cost indicator field in the Proejct Center
view.
I did refresh thecalculation (F9) in the proejct, saved and pubished.

 

[mike]

Mike --

Out of curiosity, what type of field did you set up for the formula and
Graphical Indicators?  I have assumed you are using a Number field.  Let us
know.

Mike --

Well, something is defintitely wrong somewhere. Try the following:

1. Open each of your projects individually.
2. Click Tools - Options - View.
3. Select the "Show project summary task" option (if not already
selected),
and then click the OK button.
4. Apply the Gantt chart view, if necessary.
5. Click View - Table - Cost.
5. Pull the split bar to the right and examine the Variance column for the
Project Summary Task (Task 0).

For the Project Summary Task, does the Variance column show $0.00? It
should. Let us know what you find.

news:a79c3d98-f2c2-46e5-9935-d69074f866d0@l37g2000vba.googlegroups.com....

Hello, I recently received help on a schedule formula (Thanks Dale)
and I have a similar request for Cost.
I nedd to show green for when a proejct is tracking to its basline
cost
Yellow for when it is off its basline up to 10 % over
and Red when over 10%.
Here are my current selections:
Entity (Project - I need the indicators to show in Proejct Center. )
Type - Text
Formula:
IIf([Baseline Start]=ProjDateValue("NA"),999999,[Cost Variance]/
[Baseline Cost])
Values: Graphical Indicators:
Equals 999999 Clock Face
Is Greater than .10 Red
Is Greater than 0 Yellow
Is less than or = to 0 Green
After I applied this, I opened each proejct hit F9, Saved and
Pupulished. The Projects are baselined, and no work has been
completed. My Cost Indicator is Red, whereas I am expecting it to be
Green.
Thanks again for your help,
MC- Hide quoted text -

- Show quoted text -

Dale, thank you for the quick reply.  I was in meetings from 10 till
now.

Looking at the project, in the client,  with the summary task on, the
Cost Varience column displays $0.00 , which is correct, as no tracking
has been done as of yet.

Now nothing displays in the cost indicator field in the Proejct Center
view.
I did refresh thecalculation (F9) in the proejct, saved and pubished.- Hide quoted text -

- Show quoted text -

No,

Entity : Proejct. Should this be Task? What I really need is this
graphical indicator to show in Proect View and Project Center view.
If in Project, I think it must be a Task entity.

Also chose Text not Number (text any characters)

Mike

 

[Dale Howard [MVP]]

Mike --

You used a Text field but your tests are based on numbers. I believe that
is your problem in a nutshell. You need to create the formula and Graphical
Indicators in a Number field. Also, if you want the field to be available
in a Project Center view, you need to use a Project field. If you also need
the field to show up in a detailed Project view, then you need to create
another field that uses the Task entity, and you can import both the formula
and the Graphical Indicator criteria into the second field from the first
field. That should take care of your problem. Hope this helps.

Mike --

Out of curiosity, what type of field did you set up for the formula and
Graphical Indicators? I have assumed you are using a Number field. Let us
know.

Mike --

Well, something is defintitely wrong somewhere. Try the following:

1. Open each of your projects individually.
2. Click Tools - Options - View.
3. Select the "Show project summary task" option (if not already
selected),
and then click the OK button.
4. Apply the Gantt chart view, if necessary.
5. Click View - Table - Cost.
5. Pull the split bar to the right and examine the Variance column for
the
Project Summary Task (Task 0).

For the Project Summary Task, does the Variance column show $0.00? It
should. Let us know what you find.

news:a79c3d98-f2c2-46e5-9935-d69074f866d0@l37g2000vba.googlegroups.com...

Hello, I recently received help on a schedule formula (Thanks Dale)
and I have a similar request for Cost.
I nedd to show green for when a proejct is tracking to its basline
cost
Yellow for when it is off its basline up to 10 % over
and Red when over 10%.
Here are my current selections:
Entity (Project - I need the indicators to show in Proejct Center. )
Type - Text
Formula:
IIf([Baseline Start]=ProjDateValue("NA"),999999,[Cost Variance]/
[Baseline Cost])
Values: Graphical Indicators:
Equals 999999 Clock Face
Is Greater than .10 Red
Is Greater than 0 Yellow
Is less than or = to 0 Green
After I applied this, I opened each proejct hit F9, Saved and
Pupulished. The Projects are baselined, and no work has been
completed. My Cost Indicator is Red, whereas I am expecting it to be
Green.
Thanks again for your help,
MC- Hide quoted text -

- Show quoted text -

Dale, thank you for the quick reply. I was in meetings from 10 till
now.

Looking at the project, in the client, with the summary task on, the
Cost Varience column displays $0.00 , which is correct, as no tracking
has been done as of yet.

Now nothing displays in the cost indicator field in the Proejct Center
view.
I did refresh thecalculation (F9) in the proejct, saved and pubished.-
Hide quoted text -

- Show quoted text -

No,

Entity : Proejct. Should this be Task? What I really need is this
graphical indicator to show in Proect View and Project Center view.
If in Project, I think it must be a Task entity.

Also chose Text not Number (text any characters)

Mike

 

[mike]

Mike --

You used a Text field but your tests are based on numbers.  I believe that
is your problem in a nutshell.  You need to create the formula and Graphical
Indicators in a Number field.  Also, if you want the field to be available
in a Project Center view, you need to use a Project field.  If you alsoneed
the field to show up in a detailed Project view, then you need to create
another field that uses the Task entity, and you can import both the formula
and the Graphical Indicator criteria into the second field from the first
field.  That should take care of your problem.  Hope this helps.

Mike --

Out of curiosity, what type of field did you set up for the formula and
Graphical Indicators? I have assumed you are using a Number field. Let us
know.

Mike --
Well, something is defintitely wrong somewhere. Try the following:
1. Open each of your projects individually.
2. Click Tools - Options - View.
3. Select the "Show project summary task" option (if not already
selected),
and then click the OK button.
4. Apply the Gantt chart view, if necessary.
5. Click View - Table - Cost.
5. Pull the split bar to the right and examine the Variance column for
the
Project Summary Task (Task 0).
For the Project Summary Task, does the Variance column show $0.00? It
should. Let us know what you find.


Hello, I recently received help on a schedule formula (Thanks Dale)
and I have a similar request for Cost.
I nedd to show green for when a proejct is tracking to its basline
cost
Yellow for when it is off its basline up to 10 % over
and Red when over 10%.
Here are my current selections:
Entity (Project - I need the indicators to show in Proejct Center. )
Type - Text
Formula:
IIf([Baseline Start]=ProjDateValue("NA"),999999,[Cost Variance]/
[Baseline Cost])
Values: Graphical Indicators:
Equals 999999 Clock Face
Is Greater than .10 Red
Is Greater than 0 Yellow
Is less than or = to 0 Green
After I applied this, I opened each proejct hit F9, Saved and
Pupulished. The Projects are baselined, and no work has been
completed. My Cost Indicator is Red, whereas I am expecting it to be
Green.
Thanks again for your help,
MC- Hide quoted text -
- Show quoted text -

Dale, thank you for the quick reply. I was in meetings from 10 till
now.

Looking at the project, in the client, with the summary task on, the
Cost Varience column displays $0.00 , which is correct, as no tracking
has been done as of yet.

Now nothing displays in the cost indicator field in the Proejct Center
view.
I did refresh thecalculation (F9) in the proejct, saved and pubished.-
Hide quoted text -

- Show quoted text -

No,

Entity : Proejct.  Should this be Task?  What I really need is this
graphical indicator to show in Proect View and Project Center view.
If in Project, I think it must be a Task entity.

Also chose Text not Number  (text  any characters)

Mike- Hide quoted text -

- Show quoted text -

Dale, Thnaks again !

Ug one last wrinkle. The thresholds just changed.

Now its
Green from 0- 89% complete
Yellow from (90% to 99%) To give the PM warning that schedule and cost
should be done
Green when its 100 % matching Basline complete
Red over budget or cost

 

[Dale Howard [MVP]]

Mike --

I hate to tell you, but the latest set of criteria make no sense. What if a
task is 80% done and is already 20% over budget on cost? Is that a green or
red stoplight? What if a task is 90% done but is its Duration is twice as
long as originally planned and it is precisely on budget? See? Whoever is
the source of your criteria (please tell me it isn't you) is mixing apples
and oranges and grapes.

I think you would be wise to create four custom fields with stoplight
indicators for executive reporting. They would be: Cost variance (which
you have done), Work variance (you can probably use the same formula and
graphical indicators), Duration Variance (Duration Variance/Baseline
Duration with your own organization's tolerance for Duration slippage), and
Date variance (calculated in days late using the Finish Variance field,
again with your organization's tolerance for Finish date slippage). Once
created, you could package these into a single executive dashboard View in
the Project Center. Then, at a glance, your executives can see the overall
status of each project. Hope this helps.

Mike --

You used a Text field but your tests are based on numbers. I believe that
is your problem in a nutshell. You need to create the formula and
Graphical
Indicators in a Number field. Also, if you want the field to be available
in a Project Center view, you need to use a Project field. If you also
need
the field to show up in a detailed Project view, then you need to create
another field that uses the Task entity, and you can import both the
formula
and the Graphical Indicator criteria into the second field from the first
field. That should take care of your problem. Hope this helps.

Mike --

Out of curiosity, what type of field did you set up for the formula and
Graphical Indicators? I have assumed you are using a Number field. Let
us
know.

Mike --
Well, something is defintitely wrong somewhere. Try the following:
1. Open each of your projects individually.
2. Click Tools - Options - View.
3. Select the "Show project summary task" option (if not already
selected),
and then click the OK button.
4. Apply the Gantt chart view, if necessary.
5. Click View - Table - Cost.
5. Pull the split bar to the right and examine the Variance column for
the
Project Summary Task (Task 0).
For the Project Summary Task, does the Variance column show $0.00? It
should. Let us know what you find.


Hello, I recently received help on a schedule formula (Thanks Dale)
and I have a similar request for Cost.
I nedd to show green for when a proejct is tracking to its basline
cost
Yellow for when it is off its basline up to 10 % over
and Red when over 10%.
Here are my current selections:
Entity (Project - I need the indicators to show in Proejct Center. )
Type - Text
Formula:
IIf([Baseline Start]=ProjDateValue("NA"),999999,[Cost Variance]/
[Baseline Cost])
Values: Graphical Indicators:
Equals 999999 Clock Face
Is Greater than .10 Red
Is Greater than 0 Yellow
Is less than or = to 0 Green
After I applied this, I opened each proejct hit F9, Saved and
Pupulished. The Projects are baselined, and no work has been
completed. My Cost Indicator is Red, whereas I am expecting it to be
Green.
Thanks again for your help,
MC- Hide quoted text -
- Show quoted text -

Dale, thank you for the quick reply. I was in meetings from 10 till
now.

Looking at the project, in the client, with the summary task on, the
Cost Varience column displays $0.00 , which is correct, as no tracking
has been done as of yet.

Now nothing displays in the cost indicator field in the Proejct Center
view.
I did refresh thecalculation (F9) in the proejct, saved and pubished.-
Hide quoted text -

- Show quoted text -

No,

Entity : Proejct. Should this be Task? What I really need is this
graphical indicator to show in Proect View and Project Center view.
If in Project, I think it must be a Task entity.

Also chose Text not Number (text any characters)

Mike- Hide quoted text -

- Show quoted text -

Dale, Thnaks again !

Ug one last wrinkle. The thresholds just changed.

Now its
Green from 0- 89% complete
Yellow from (90% to 99%) To give the PM warning that schedule and cost
should be done
Green when its 100 % matching Basline complete
Red over budget or cost