Checking for "NA" in Baseline Finish column (or any column) using formula

[anovaktx]

I am using the following formula for graphical indicator for Schedule
"Health".

Switch([% Complete]=100,"0",
DateValue([Finish])>DateValue([Baseline Finish]),"1",
DateValue([Finish])=DateValue([Baseline Finish]),"2",
DateValue([Finish])<DateValue([Baseline Finish]),"3",
DateValue([Baseline Finish])="NA","1")

1=Red
2=Yellow
3=Green

I want to show "1" (Red) if there is NO Baseline Finish, that is if the
PM has not taken a Baseline. Looking at the Baseline Finish value in
the PWA view, it shows visually as a "NA" if there is no Baseline.
What function / value to I need to use that ties back to a "NA" on the
screen?

Thanks,
Andy Novak
University of North Texas

 

[Marc Soester]

Hi Andy,

try the following:

Baseline Finish = Projectdatevalue("NA")
that should do the job