#Error on Number Schedule Indicator when Baseline Not Set Yet

W

Wendy

Hi I have an enterprise number schedule indicator and
when the baseline is not set this returns #Error. How
can I change this formula and have it return 0? I am
trying to trap the error meaning if there is no baseline
make it 0 which is green. I have tried everything but I
can't figure out how to trap in a number field for
#error. Here is my formula. Any assistance with this
would be great. Thanks

Switch(([% Complete]=100) And Trim([Enterprise Text2])
="Yes",0,((ProjDateDiff([Start],[Baseline7 Start])
\[Minutes Per Day]>=0) And ([% Complete]<100)) And Trim
([Enterprise Text2])="Yes",0,((ProjDateDiff([Start],
[Baseline7 Start])\[Minutes Per Day]<0) And (ProjDateDiff
([Start],[Baseline7 Start])\[Minutes Per Day]>=(-15)) And
([% Complete]<100)) And Trim([Enterprise Text2])="Yes",0,
((ProjDateDiff([Start],[Baseline7 Start])\[Minutes Per
Day]<15) And (ProjDateDiff([Start],[Baseline7 Start])
\[Minutes Per Day]>=(-30)) And ([% Complete]<100)) And
Trim([Enterprise Text2])="Yes",1,((ProjDateDiff([Start],
[Baseline7 Start])\[Minutes Per Day]<(-30)) And ([%
Complete]<100)) And Trim([Enterprise Text2])="Yes",2,Trim
([Enterprise Text2])="No",0)
 
B

Brian K - Project MVP

Wendy said:
Hi I have an enterprise number schedule indicator and
when the baseline is not set this returns #Error. How
can I change this formula and have it return 0? I am
trying to trap the error meaning if there is no baseline
make it 0 which is green. I have tried everything but I
can't figure out how to trap in a number field for
#error. Here is my formula. Any assistance with this
would be great. Thanks

Switch(([% Complete]=100) And Trim([Enterprise Text2])
="Yes",0,((ProjDateDiff([Start],[Baseline7 Start])
\[Minutes Per Day]>=0) And ([% Complete]<100)) And Trim
([Enterprise Text2])="Yes",0,((ProjDateDiff([Start],
[Baseline7 Start])\[Minutes Per Day]<0) And (ProjDateDiff
([Start],[Baseline7 Start])\[Minutes Per Day]>=(-15)) And
([% Complete]<100)) And Trim([Enterprise Text2])="Yes",0,
((ProjDateDiff([Start],[Baseline7 Start])\[Minutes Per
Day]<15) And (ProjDateDiff([Start],[Baseline7 Start])
\[Minutes Per Day]>=(-30)) And ([% Complete]<100)) And
Trim([Enterprise Text2])="Yes",1,((ProjDateDiff([Start],
[Baseline7 Start])\[Minutes Per Day]<(-30)) And ([%
Complete]<100)) And Trim([Enterprise Text2])="Yes",2,Trim
([Enterprise Text2])="No",0)
Click to expand...

Try this: [baseline7 start] = ProjDateValue("NA")

This will trap the absence of a date in the baseline date fields.
 
Top