Checking for Baselines

S

SRidge

I have a process where I baseline a project at 4 different
stages of the project (we use BL1, BL2, BL3 and BL4). I
want to enable an error trapping routine that checks if a
baseline was actually set therefore allowing me to report
on the status. P2002 foces "NA" into the BL1 Start & BL1
Finish fields if the baseline has not been set. Here's my
question:

Is there a way to identify whether a baseline has been
set? I have tried the IIF, IsNull, ISNumeric functions
and they don't result in anything tangible.
 
1

10K

SRidge,
Quite curious.

I was able to create an awkward workaround.

Define field TextN as [BaselineN Finish] (for examnple). Don't worry about
summary rollup.

Then, create FlagN as [TextN]<>"NA". Set Calculation for summary rows as
AND. The Flag will by Yes if the task is baselined and No if not baselined.
Good luck,
10K
 
S

SRidge

Thanks. I will give this a try.
-----Original Message-----
SRidge,
Quite curious.

I was able to create an awkward workaround.

Define field TextN as [BaselineN Finish] (for examnple). Don't worry about
summary rollup.

Then, create FlagN as [TextN]<>"NA". Set Calculation for summary rows as
AND. The Flag will by Yes if the task is baselined and No if not baselined.
Good luck,
10K

SRidge said:
I have a process where I baseline a project at 4 different
stages of the project (we use BL1, BL2, BL3 and BL4). I
want to enable an error trapping routine that checks if a
baseline was actually set therefore allowing me to report
on the status. P2002 foces "NA" into the BL1 Start & BL1
Finish fields if the baseline has not been set. Here's my
question:

Is there a way to identify whether a baseline has been
set? I have tried the IIF, IsNull, ISNumeric functions
and they don't result in anything tangible.
Click to expand...
.
Click to expand...
 
D

Dale Howard [MVP]

SRidge --

Insert the following formula in any custom Text field:

IIf([Baseline Finish]>54789,"No","Yes")

The formula traps the "NA" value in the Baseline Finish field. Insert the
custom Text field in any task table and you will see if any task has not
been baselined. Hope this helps.

--
Dale A. Howard [MVP]
Enterprise Project Trainer/Consultant
Denver, Colorado
http://www.msprojectexperts.com
"We wrote the book on Project Server"
 
Top