jb --
I've got a model working that I believe meets your reporting requirements.
First of all, I have renamed the following fields:
Enterprise Project Date1 = Submitted Date
Enterprise Project Date2 = Requested Date
Enterprise Project Date3 = Baseline Release Date
I have not set up a separate field called Actual Release Date, as I am
assuming that would be the Finish date of the project. Then I have renamed
the following fields and have entered the following formula in each field:
Enterprise Project Duration1 = Cycle Time
Formula = IIf([Enterprise Project Date1]>54789,0,ProjDateDiff([Enterprise
Project Date1],[Finish],"msPE"))
Enterprise Project Duration2 = Speed of Business
IIf([Enterprise Project Date2]>54789,0,ProjDateDiff([Enterprise Project
Date2],[Finish],"msPE"))
Enterprise Project Duration3 = Commitment Variance
IIf([Enterprise Project Date3]>54789,0,ProjDateDiff([Enterprise Project
Date3],[Finish],"msPE"))
In each of the formulas, I first "trap" errors caused by the user not
entering one of these three custom fields. If they have not entered a
Submitted, Requested, or Baseline Release Date value, then the appropriate
Duration field will calculate a variance of 0 days. I am also using the
Finish date of the project in each of these formulas, though you could
substitute your own custom Date field is you need to do so. In addition, I
am using the DateDiff calculations based on my company calendar (msPE) which
is the Project Calendar for each project.
To enter values for the custom Date fields, I open the project and then
click Project - Project Information, and enter the desired Date values.
Then I close the dialog box and click the F9 key to recalculate the project.
Then I reopen the Project Information dialog box and the custom Duration
fields have been recalculated. I am seeing no errors whatsoever, and
correct Duration values as far as I can tell.
To "push" these field values to PWA, I simply click Collaborate - Publish -
All Information. I have also created a custom Project Center view to
display these fields and everything is displaying correctly in PWA. Let me
know if this helps your situation. If not, e-mail me privately and we'll
decide where to go from here.
jb said:
To add to my earlier post. These projects are in que and
don't get started right away. That is why I need them to
plug in dates from the tool.
thx
jb
-----Original Message-----
jb --
I would like to be able to help you with your formula problem, so let me ask
a couple of questions:
1. What are you attempting to accomplish by the use of these enterprise
fields and formulas? Please be precise and don't generalize.
2. Exactly what custom enterprise fields are you using? Enterprise Task
Duration fields or Enterprise Project Duration fields?
3. Where are you seeing the zeroes in the Enterprise Duration columns? A
custom Table in Microsoft Project 2002 or a custom View in PWA?
4. If you have created a custom Table in Project 2002 containing your
enterprise Duration columns, have you clicked Tools - Options - Calculate,
and then clicked the Recalculate Now button?
5. I you have created a custom View in PWA, did you click Collaborate -
Publish - Project Plan (or All Information) for each project in which you
want to see these enterprise Duration columns?
Please let me know, and I will be glad to help you.
jb said:
I am still not getting my custom fields to calculate the
duration difference. All of them = 0days.
One field I have created is the formula below. This should
match up to finish variance but it never does. It always
is 0days.
Enterprise Duration3 = ProjDateDiff([Finish],[Baseline
Finish])
another formula is
Enterprise Duration2 = ProjDateDiff([Enterprise Project
Date2],[Finish])
always = 0 days
How can I get this to calculate? I have it to calculate
automatically.
thx
jb
.
