Check ([Baseline Finish]>50000 When Baseline Does Not Exist Doesn't Work

W

Wendy

Can anyone tell me why the first line does not work?

The first switch should catch that there is no baseline
and return a 0 instead it returns #Error.

Switch([Baseline Finish]>50000,0,ProjDateDiff([Baseline
Finish],[Finish])/480>=2,2,ProjDateDiff([Baseline Finish],
[Finish])/480>=1,1,True,0)

Please let me know what I need to change on the formula.

Thanks,
Wendy
 
G

Gary L. Chefetz \(MVP\)

Wendy:

Try substituting

Switch(Len(CStr([Baseline Finish]))<3,0,

In the future, you'll get much better response if you post to
microsoft.public.project.developer
--

Gary L. Chefetz, MVP
"We wrote the book on Project Server
http://www.msprojectexperts.com

-
 
Top