D
Dylan
Question 1:
I'm trying to create an indicator on Project Center that shows whether each
project is over/under budget. I created an Enterprise Project field in
Project Server and used the following formula...
Switch([Cost Variance]=[Cost],"No Baseline",abs([Cost Variance]/[Baseline
Cost])<=0.1,"Green",abs([Cost Variance]/[Baseline Cost])>0.1 And abs([Cost
Variance]/[Baseline Cost])<=0.2,"Yellow",abs([Cost Variance]/[Baseline
Cost])>0.2,"Red")
This works for everything except the "No Baseline" in MS Project
Professional 2007. How can I get the "No Baseline" to work? The following
formula does present "No Baseline" correctly...
IIf([Cost Variance]=[Cost],"No Baseline",abs([Cost Variance]/[Baseline Cost]))
Question 2:
The indicators in Project Center are not showing correctly. The words
"Green", "Yellow", "Red" are shown instead. I've tried reopening the projects
and resetting the baselines and republishing them to no avail. How can I get
them to present correctly?
Your assistance is greatly appreciated.
I'm trying to create an indicator on Project Center that shows whether each
project is over/under budget. I created an Enterprise Project field in
Project Server and used the following formula...
Switch([Cost Variance]=[Cost],"No Baseline",abs([Cost Variance]/[Baseline
Cost])<=0.1,"Green",abs([Cost Variance]/[Baseline Cost])>0.1 And abs([Cost
Variance]/[Baseline Cost])<=0.2,"Yellow",abs([Cost Variance]/[Baseline
Cost])>0.2,"Red")
This works for everything except the "No Baseline" in MS Project
Professional 2007. How can I get the "No Baseline" to work? The following
formula does present "No Baseline" correctly...
IIf([Cost Variance]=[Cost],"No Baseline",abs([Cost Variance]/[Baseline Cost]))
Question 2:
The indicators in Project Center are not showing correctly. The words
"Green", "Yellow", "Red" are shown instead. I've tried reopening the projects
and resetting the baselines and republishing them to no avail. How can I get
them to present correctly?
Your assistance is greatly appreciated.