Custom Date Field for Computing Variance with the Deliverable Date

C

Chris_J_S

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.
 
D

Dale Howard [MVP]

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.
 
C

Chris_J_S

Dale - many thanks - YOU DA MAN! One more thing you can do to improve the
formula: substitute [Project Calendar] for "Standard" --- this will force the
formula to use whatever is the declared Calendar for the Project.

Chris_J_S

Dale Howard said:
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.
 
D

Dale Howard [MVP]

Chris_J_S --

Thanks for the additional tip. :)




Chris_J_S said:
Dale - many thanks - YOU DA MAN! One more thing you can do to improve the
formula: substitute [Project Calendar] for "Standard" --- this will force
the
formula to use whatever is the declared Calendar for the Project.

Chris_J_S

Dale Howard said:
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top