Chris_J_S --
You are not going to believe this (I don't believe it myself), but the
[Deliverable Start] and [Deliverable Finish] fields are available fields
in
the Custom Fields dialog. It's just that they don't show up as available
Fields when you click the Field pick list in the Formula dialog. I
created
a custom Duration field for the Task type, named it Deliverable Start
Variance, and manually typed the entire following formula:
IIf([Deliverable Start] = ProjDateValue("NA"), 0,
ProjDateDiff([Deliverable
Start], [Start], "Standard"))
I fully expected an error when I clicked the OK button, but to my
amazement,
there was no error. The software accepted everything I typed! And the
formula does work. Using the above formula in a Duration field, if a
task
has no Deliverable Start date (meaning that the task does not have an
attached Deliverable), then the formula returns 0 days Duration. If the
task does have a Deliverable Start date, the software subtracts the
difference between the current Start date and the original Deliverable
Start
date and returns the answer in working days defined by the enterprise
Standard calendar. A positive number is the number of days beyond which
the
Finish date has slipped past the original Deliverable Start date. You
could
create another Duration field called Deliverable Finish Variance and use
the
following formula:
IIf([Deliverable Finish ] = ProjDateValue("NA"), 0,
ProjDateDiff([Deliverable Finish], [Finish], "Standard"))
By answering your question today, I learned something new! So thanks for
helping me!!
Hope this helps you as well.
Chris_J_S said:
Does anybody know of a way to compute a variance with the Deliverable
Start
or Finish Dates? I was going to create one using Custom Fields with
one
of
Custom Duration fields, however, I noticed that Deliverable Start and
Deliverable Finish are not selectable fields in the formula section of
the
customization.