EV indicator Stoplight shows red although the task is complete

[Casper]

Here is the formula we use for the EV (The Earned Value field we use is a
Number Custom Field) stoplight indicators:

IIf(([BCWP]>0) Or ([BCWS]>0),IIf([BCWS]<=[BCWP],IIf([Physical %
Complete]=95,3,1),IIf([Physical % Complete]=95,4,2)),0)

The problem is as follows: When we open the project plan in Project
Professional, all the stoplights display green for completed tasks, but as
soon as we save the same project plan as an Enterprise project on Project
Server 2003, two or three of the completed tasks shows red for the stoplights.

After saving the project as an enterprise project, I had a look at the
formula and it's still the same.

Any ideas?

 

[Dale Howard [MVP]]

Casper --

If you press the F9 function key to recalculate the project, does this
resolve the problem? Let us know.

 

[Casper]

I've tried that but the result is still the same. On by Demo EPM servers also
running Project Server 2003, it works fine. I've tried to do a comparison
between my development environment and the environment at the client and all
the settings looks the same. Can it be a service pack issue, because that is
onething that is different?

Casper --

If you press the F9 function key to recalculate the project, does this
resolve the problem? Let us know.

Here is the formula we use for the EV (The Earned Value field we use is a
Number Custom Field) stoplight indicators:

IIf(([BCWP]>0) Or ([BCWS]>0),IIf([BCWS]<=[BCWP],IIf([Physical %
Complete]=95,3,1),IIf([Physical % Complete]=95,4,2)),0)

The problem is as follows: When we open the project plan in Project
Professional, all the stoplights display green for completed tasks, but as
soon as we save the same project plan as an Enterprise project on Project
Server 2003, two or three of the completed tasks shows red for the
stoplights.

After saving the project as an enterprise project, I had a look at the
formula and it's still the same.

Any ideas?

 

[Dale Howard [MVP]]

Casper --

I'm only speculating here, but yes, it might be a Service Pack issue. Make
sure you have the same SP level on the production server that you do on the
demo server and see if that helps.

I've tried that but the result is still the same. On by Demo EPM servers
also
running Project Server 2003, it works fine. I've tried to do a comparison
between my development environment and the environment at the client and
all
the settings looks the same. Can it be a service pack issue, because that
is
onething that is different?

Casper --

If you press the F9 function key to recalculate the project, does this
resolve the problem? Let us know.

Here is the formula we use for the EV (The Earned Value field we use is
a
Number Custom Field) stoplight indicators:

IIf(([BCWP]>0) Or ([BCWS]>0),IIf([BCWS]<=[BCWP],IIf([Physical %
Complete]=95,3,1),IIf([Physical % Complete]=95,4,2)),0)

The problem is as follows: When we open the project plan in Project
Professional, all the stoplights display green for completed tasks, but
as
soon as we save the same project plan as an Enterprise project on
Project
Server 2003, two or three of the completed tasks shows red for the
stoplights.

After saving the project as an enterprise project, I had a look at the
formula and it's still the same.

Any ideas?

 

[Casper]

Thanks Dale. What will the implication be if I replace the Global template
with the one on the Dev. environment. All the settings are more or less the
same?

Casper --

I'm only speculating here, but yes, it might be a Service Pack issue. Make
sure you have the same SP level on the production server that you do on the
demo server and see if that helps.

I've tried that but the result is still the same. On by Demo EPM servers
also
running Project Server 2003, it works fine. I've tried to do a comparison
between my development environment and the environment at the client and
all
the settings looks the same. Can it be a service pack issue, because that
is
onething that is different?

Casper --

If you press the F9 function key to recalculate the project, does this
resolve the problem? Let us know.




Here is the formula we use for the EV (The Earned Value field we use is
a
Number Custom Field) stoplight indicators:

IIf(([BCWP]>0) Or ([BCWS]>0),IIf([BCWS]<=[BCWP],IIf([Physical %
Complete]=95,3,1),IIf([Physical % Complete]=95,4,2)),0)

The problem is as follows: When we open the project plan in Project
Professional, all the stoplights display green for completed tasks, but
as
soon as we save the same project plan as an Enterprise project on
Project
Server 2003, two or three of the completed tasks shows red for the
stoplights.

After saving the project as an enterprise project, I had a look at the
formula and it's still the same.

Any ideas?

 

[Dale Howard [MVP]]

Casper --

Before you would attempt to restore a Global template from the Dev.
environment, back up the Enterprise Global in the Prod. environment using
Tools - Enterprise Options - Back Up Enterprise Global. Do this as a
fallback in case the restoration process fails. You can try it if you want,
but I take no responsibility whatsoever for the results. Hope this helps.

Thanks Dale. What will the implication be if I replace the Global template
with the one on the Dev. environment. All the settings are more or less
the
same?

Casper --

I'm only speculating here, but yes, it might be a Service Pack issue.
Make
sure you have the same SP level on the production server that you do on
the
demo server and see if that helps.

I've tried that but the result is still the same. On by Demo EPM
servers
also
running Project Server 2003, it works fine. I've tried to do a
comparison
between my development environment and the environment at the client
and
all
the settings looks the same. Can it be a service pack issue, because
that
is
onething that is different?

:

Casper --

If you press the F9 function key to recalculate the project, does this
resolve the problem? Let us know.




Here is the formula we use for the EV (The Earned Value field we use
is
a
Number Custom Field) stoplight indicators:

IIf(([BCWP]>0) Or ([BCWS]>0),IIf([BCWS]<=[BCWP],IIf([Physical %
Complete]=95,3,1),IIf([Physical % Complete]=95,4,2)),0)

The problem is as follows: When we open the project plan in Project
Professional, all the stoplights display green for completed tasks,
but
as
soon as we save the same project plan as an Enterprise project on
Project
Server 2003, two or three of the completed tasks shows red for the
stoplights.

After saving the project as an enterprise project, I had a look at
the
formula and it's still the same.

Any ideas?

 

[Casper]

Thanks Dale

No worries, I'll take the blame

Casper --

Before you would attempt to restore a Global template from the Dev.
environment, back up the Enterprise Global in the Prod. environment using
Tools - Enterprise Options - Back Up Enterprise Global. Do this as a
fallback in case the restoration process fails. You can try it if you want,
but I take no responsibility whatsoever for the results. Hope this helps.

Thanks Dale. What will the implication be if I replace the Global template
with the one on the Dev. environment. All the settings are more or less
the
same?

Casper --

I'm only speculating here, but yes, it might be a Service Pack issue.
Make
sure you have the same SP level on the production server that you do on
the
demo server and see if that helps.




I've tried that but the result is still the same. On by Demo EPM
servers
also
running Project Server 2003, it works fine. I've tried to do a
comparison
between my development environment and the environment at the client
and
all
the settings looks the same. Can it be a service pack issue, because
that
is
onething that is different?

:

Casper --

If you press the F9 function key to recalculate the project, does this
resolve the problem? Let us know.




Here is the formula we use for the EV (The Earned Value field we use
is
a
Number Custom Field) stoplight indicators:

IIf(([BCWP]>0) Or ([BCWS]>0),IIf([BCWS]<=[BCWP],IIf([Physical %
Complete]=95,3,1),IIf([Physical % Complete]=95,4,2)),0)

The problem is as follows: When we open the project plan in Project
Professional, all the stoplights display green for completed tasks,
but
as
soon as we save the same project plan as an Enterprise project on
Project
Server 2003, two or three of the completed tasks shows red for the
stoplights.

After saving the project as an enterprise project, I had a look at
the
formula and it's still the same.

Any ideas?

 

[Dale Howard [MVP]]

Casper --

You are more than welcome, my friend. Let us know how this turns out.

Thanks Dale

No worries, I'll take the blame

Casper --

Before you would attempt to restore a Global template from the Dev.
environment, back up the Enterprise Global in the Prod. environment using
Tools - Enterprise Options - Back Up Enterprise Global. Do this as a
fallback in case the restoration process fails. You can try it if you
want,
but I take no responsibility whatsoever for the results. Hope this
helps.

Thanks Dale. What will the implication be if I replace the Global
template
with the one on the Dev. environment. All the settings are more or less
the
same?

:

Casper --

I'm only speculating here, but yes, it might be a Service Pack issue.
Make
sure you have the same SP level on the production server that you do
on
the
demo server and see if that helps.




I've tried that but the result is still the same. On by Demo EPM
servers
also
running Project Server 2003, it works fine. I've tried to do a
comparison
between my development environment and the environment at the client
and
all
the settings looks the same. Can it be a service pack issue, because
that
is
onething that is different?

:

Casper --

If you press the F9 function key to recalculate the project, does
this
resolve the problem? Let us know.




Here is the formula we use for the EV (The Earned Value field we
use
is
a
Number Custom Field) stoplight indicators:

IIf(([BCWP]>0) Or ([BCWS]>0),IIf([BCWS]<=[BCWP],IIf([Physical %
Complete]=95,3,1),IIf([Physical % Complete]=95,4,2)),0)

The problem is as follows: When we open the project plan in
Project
Professional, all the stoplights display green for completed
tasks,
but
as
soon as we save the same project plan as an Enterprise project on
Project
Server 2003, two or three of the completed tasks shows red for
the
stoplights.

After saving the project as an enterprise project, I had a look
at
the
formula and it's still the same.

Any ideas?