Project server 2007: Custom Fields and Custom Calculations

[Usman Ahmad]

Hi.
My users are very basic so I need to do most of the things righ on the
STANDARD TEMPLATE to get them to do their work. The thing is, I have a ton of
Enterprise Fields on the Project Level as well as on the Task Level. I
frequently need to perform some routines as a value is entered in each. for
example, I have about 7 custom COST fields defined on the Enterprise
Template. I need to perform some calculation on the values in each field and
represent the total in the default COST/TOTAL COST field. How and where do I
create my custom formula or module and how do I call it on each task data
entry/change?

 

[Ben Howard]

Lots of fields....

They are created in Server Settings | Enterprise custom fields. They will
calculate as per the automatic/manual calculation field in project setting.
F9 manually recalcs....

 

[Usman Ahmad]

Thanks for your reply.
Maybe my question wasn't clear. I know how to create Enterprise Custom
Fields and apply formulae and such. My problem is that I want to sum up all
the enteries in these Custom Fields that I created and show the total in the
COST field (already provided by MS Project) of the Task.
Do I create a module or a macro and how and where can I call the macro? I
want the total to reflect the changes (if any) as soon as they are made.

 

[Ben Howard]

I believe between myself and johnathan we have jus answered this.

 

[Usman Ahmad]

I am sorry for being so thick. Could we go over this again? Right now, I
wrote some VBA Code within the BeforeTaskChange() method to manually
calculate and update the Project/Enterprise fields accordingly (Cost,
EnterpriseCost1).

Is there an out-of-the-box way to do this?

And, how do I create views to display summation of these Enterprise Fields?
For example, I have an Enterprise Custom Field defined for TASKs. Can I have
a PROJECT SUMMARY view where I can show the sum of this Enterprise Field
against each project?