Duration Formulas

[Eric Stevens]

All,

Here are the three formulas I am trying to calculate.

Proj Completion Time Variance(Enterprise Proj Duration 1)
= ProjDateDiff([Enterprise Project Date1],[Start])

Client Delivery Expected Variance(Enterprise Proj Duration
2) = ProjDateDiff([Enterprise Project Date2],[Finish])

On Time Delivery Variance(Enterprise Proj Duration 3) =
ProjDateDiff([Finish],[Baseline Finish])

The third one should equal Finish Variance. My results are
0 in the top level with error shooting down the tasks. I
am just trying to get some durations between custome
dates. Can anyone help?

Thanks,
Eric

 

[Jack D.]

All,

Here are the three formulas I am trying to calculate.

Proj Completion Time Variance(Enterprise Proj Duration 1)
= ProjDateDiff([Enterprise Project Date1],[Start])

Client Delivery Expected Variance(Enterprise Proj Duration
2) = ProjDateDiff([Enterprise Project Date2],[Finish])

On Time Delivery Variance(Enterprise Proj Duration 3) =
ProjDateDiff([Finish],[Baseline Finish])

The third one should equal Finish Variance. My results are
0 in the top level with error shooting down the tasks. I
am just trying to get some durations between custome
dates. Can anyone help?

Thanks,
Eric

There could be a number of reasons for this.
1) You have no data in the Enterprise Project Date fields
2) Calculation is set to manual
3) You are using a duration field. Try using a text field.

I am assuming that you are including the first part of the formula just for
reference.
Only that which is AFTER the = sign should be entered into the formula box.


--
Please try to keep replies in this group. I do check e-mail, but only
infrequently. For Macros and other things check http://masamiki.com/project

-Jack Dahlgren, Project MVP


+++++++++++++++++++

 

[Eric Stevens]

Thanks Jack for the feedback. I plugged the formulas in
the text field and now they are blank. I do have values in
my enterprise fields and have automatc calculation set.
Are my formulas below correct? I can not even get a value
for the third formula(finish variance). Help!!! I
appreciate it.
thanks,
eric

-----Original Message-----

All,

Here are the three formulas I am trying to calculate.

Proj Completion Time Variance(Enterprise Proj Duration 1)
= ProjDateDiff([Enterprise Project Date1],[Start])

Client Delivery Expected Variance(Enterprise Proj Duration
2) = ProjDateDiff([Enterprise Project Date2],[Finish])

On Time Delivery Variance(Enterprise Proj Duration 3) =
ProjDateDiff([Finish],[Baseline Finish])

The third one should equal Finish Variance. My results are
0 in the top level with error shooting down the tasks. I
am just trying to get some durations between custome
dates. Can anyone help?

Thanks,
Eric

There could be a number of reasons for this.
1) You have no data in the Enterprise Project Date fields
2) Calculation is set to manual
3) You are using a duration field. Try using a text field.

I am assuming that you are including the first part of the formula just for
reference.
Only that which is AFTER the = sign should be entered into the formula box.


--
Please try to keep replies in this group. I do check e- mail, but only
infrequently. For Macros and other things check http://masamiki.com/project

-Jack Dahlgren, Project MVP


+++++++++++++++++++


.

 

[Jack D.]

When you customize the enterprise project fields you need to close project
pro and restart it for it to pick up the changed fields.
Did you try that?
I can't help you troubleshoot any further as I do not have project pro
installed so I can't get to those fields.
You can trouble shoot by starting simple using a formula like this:
[Baseline Finish]
and checking if that returns a value. Make sure that all your fields return
a valid result
Then start using the other functions like projdatediff.

-Jack

Thanks Jack for the feedback. I plugged the formulas in
the text field and now they are blank. I do have values in
my enterprise fields and have automatc calculation set.
Are my formulas below correct? I can not even get a value
for the third formula(finish variance). Help!!! I
appreciate it.
thanks,
eric

-----Original Message-----

All,

Here are the three formulas I am trying to calculate.

Proj Completion Time Variance(Enterprise Proj Duration 1)
= ProjDateDiff([Enterprise Project Date1],[Start])

Client Delivery Expected Variance(Enterprise Proj Duration
2) = ProjDateDiff([Enterprise Project Date2],[Finish])

On Time Delivery Variance(Enterprise Proj Duration 3) =
ProjDateDiff([Finish],[Baseline Finish])

The third one should equal Finish Variance. My results are
0 in the top level with error shooting down the tasks. I
am just trying to get some durations between custome
dates. Can anyone help?

Thanks,
Eric

There could be a number of reasons for this.
1) You have no data in the Enterprise Project Date fields
2) Calculation is set to manual
3) You are using a duration field. Try using a text field.

I am assuming that you are including the first part of the formula just for
reference.
Only that which is AFTER the = sign should be entered into the formula box.


--
Please try to keep replies in this group. I do check e- mail, but only
infrequently. For Macros and other things check
http://masamiki.com/project

-Jack Dahlgren, Project MVP


+++++++++++++++++++


.

--
Please try to keep replies in this group. I do check e-mail, but only
infrequently. For Macros and other things check http://masamiki.com/project

-Jack Dahlgren, Project MVP


+++++++++++++++++++