#Error in Graphical Indicator before Save Baseline.

W

Wendy

Hi, I have a formula below that displays #error for my
schedule indicator until a baseline is saved. Does
anyone know what I should change in this formula to have
it show 0 instead of #Error until the baseline is saved?

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

Thanks for your assistance,
Wendy
 
S

Sumit

This is from the Microsoft's material right? yes that gives error. you can add a line to check if baseline finish = 0.

Hope this helps.
Regards,
Sumit
 
W

Wendy

I added the following check but I still get the error
message. I am project manager and not very good at the
defining the enterprise code since they are more like
development. Yes this is the one from Microsoft.

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

Can you please let me know exactly what is wrong with
this formula.

I truly appreciate your help.

Thanks,
-----Original Message-----
This is from the Microsoft's material right? yes that
Click to expand...
gives error. you can add a line to check if baseline
finish = 0.
Hope this helps.
Regards,
Sumit

Wendy said:
Hi, I have a formula below that displays #error for my
schedule indicator until a baseline is saved. Does
anyone know what I should change in this formula to have
it show 0 instead of #Error until the baseline is saved?

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

Thanks for your assistance,
Wendy
Click to expand...
.
Click to expand...
 
Top