Hello,
I have been trying to use a formula from a previous post to measure the number of days between finish and baseline finish. The formula I have been trying to use is:
IIf(IsDate([Finish])=No,"No Finish",IIf([Baseline Finish]=ProjDateValue("NA"),"No Baseline Finish",int([Finish]-[Baseline Finish])))
The formula seems to work to a point. However, if the schedule has not been baselined then a '#ERROR' occurs.
Does anyone know how to amend the formula so that it returns 'No Baseline Finish' rather than #ERROR statement?
Your help would be much appreciated
Best regards
Planner
I have been trying to use a formula from a previous post to measure the number of days between finish and baseline finish. The formula I have been trying to use is:
IIf(IsDate([Finish])=No,"No Finish",IIf([Baseline Finish]=ProjDateValue("NA"),"No Baseline Finish",int([Finish]-[Baseline Finish])))
The formula seems to work to a point. However, if the schedule has not been baselined then a '#ERROR' occurs.
Does anyone know how to amend the formula so that it returns 'No Baseline Finish' rather than #ERROR statement?
Your help would be much appreciated
Best regards
Planner