Earned value analysis Project Schedule and Project budget

[johnson]

I don’t seem to ascertain what wrong I am doing. I have customized two
project level text fields for indicating the status of project schedule and
project budget in earned value analysis.

For “Project Schedule†in Project Text 1 field ,I have customized it us under:
IIf([BCWP]=0 Or [BCWP]<0,"Not started",IIf([BCWP]>0 And [BCWS]=[BCWP],"At
Par",IIf([BCWS]<[BCWP],"Ahead",IIf([BCWS]>[BCWP],"Behind"," NA"))))

For “Project Budget†in Project text 2 field ,I have customized it us under:

IIf([BCWP]=0 Or [BCWP]<0,"Not started",IIf([BCWP]>0 And [ACWP]=[BCWP],"At
Par",IIf([ACWP]<[BCWP],"Underrun",IIf([ACWP]>[BCWP],"Overrun"," NA"))))

I want to indicate status of budget and schedule as at
Par/behind/ahead/overrun /underrun etc by comparing the values of
BCWP/BCWS/Acwp

For some projects I am getting error in the customized fields in PWA.
Can any one come to my rescue please?

 

[Dale Howard [MVP]]

Johnson --

Open the troublesome projects and then press the F9 function key to
recalculate the project. Let us know if this solves the problem.

 

[Paul Conroy]

Also check that each of the projects has a baseline.

 

[johnson]

Dale, Paul,
Yes,Thanks a lot. I have pressed F9 key and saved a baseline.It is working.
Thanks once again
--
Johnson

Also check that each of the projects has a baseline.

I don’t seem to ascertain what wrong I am doing. I have customized two
project level text fields for indicating the status of project schedule and
project budget in earned value analysis.

For “Project Schedule†in Project Text 1 field ,I have customized it us under:
IIf([BCWP]=0 Or [BCWP]<0,"Not started",IIf([BCWP]>0 And [BCWS]=[BCWP],"At
Par",IIf([BCWS]<[BCWP],"Ahead",IIf([BCWS]>[BCWP],"Behind"," NA"))))

For “Project Budget†in Project text 2 field ,I have customized it us under:

IIf([BCWP]=0 Or [BCWP]<0,"Not started",IIf([BCWP]>0 And [ACWP]=[BCWP],"At
Par",IIf([ACWP]<[BCWP],"Underrun",IIf([ACWP]>[BCWP],"Overrun"," NA"))))

I want to indicate status of budget and schedule as at
Par/behind/ahead/overrun /underrun etc by comparing the values of
BCWP/BCWS/Acwp

For some projects I am getting error in the customized fields in PWA.
Can any one come to my rescue please?

 

[Dale Howard [MVP]]

Johnson --

You are more than welcome for the help, my friend!

Dale, Paul,
Yes,Thanks a lot. I have pressed F9 key and saved a baseline.It is
working.
Thanks once again
--
Johnson

Also check that each of the projects has a baseline.

I don't seem to ascertain what wrong I am doing. I have customized two
project level text fields for indicating the status of project
schedule and
project budget in earned value analysis.

For "Project Schedule" in Project Text 1 field ,I have customized it us
under:
IIf([BCWP]=0 Or [BCWP]<0,"Not started",IIf([BCWP]>0 And
[BCWS]=[BCWP],"At
Par",IIf([BCWS]<[BCWP],"Ahead",IIf([BCWS]>[BCWP],"Behind"," NA"))))

For "Project Budget" in Project text 2 field ,I have customized it us
under:

IIf([BCWP]=0 Or [BCWP]<0,"Not started",IIf([BCWP]>0 And
[ACWP]=[BCWP],"At
Par",IIf([ACWP]<[BCWP],"Underrun",IIf([ACWP]>[BCWP],"Overrun"," NA"))))

I want to indicate status of budget and schedule as at
Par/behind/ahead/overrun /underrun etc by comparing the values of
BCWP/BCWS/Acwp

For some projects I am getting error in the customized fields in PWA.
Can any one come to my rescue please?