Cost field task addition

[Jesse Schuchart]

I have created 6 Enterprise Custom Fields for tracking expense and capital
costs.

When I enter a value into the fields, the Cost field for the project is not
increasing. The cost field is only displaying the cost for the resources,
not for the resource plus any other fields that are of a cost type.

I attempted to create a formula for adding the custom fields:

= [Budget Capital - Hardware] + [Budget Capital - Software]

but Project displays Error

How do I display the full cost of the project?

 

[Jan De Messemaeker]

Hi,

Formulas will not help you, since they can only be used in custom fields and
Cost is not one.
You might put a formula in say Cost7 to say Cost+Cost1 etc.
If you know VBA, you can add your own fields to task's fixed cost, which in
turn is added to Cost by Project.
Hope this helps,

 

[Jesse Schuchart]

I know VBA, but I need a little push in the right direction.

Where would I find a sample of code to complete what you recommended.

Hi,

Formulas will not help you, since they can only be used in custom fields and
Cost is not one.
You might put a formula in say Cost7 to say Cost+Cost1 etc.
If you know VBA, you can add your own fields to task's fixed cost, which in
turn is added to Cost by Project.
Hope this helps,


--
Jan De Messemaeker
Microsoft Project MVP
http://users.online.be/prom-ade

I have created 6 Enterprise Custom Fields for tracking expense and capital
costs.

When I enter a value into the fields, the Cost field for the project is
not
increasing. The cost field is only displaying the cost for the resources,
not for the resource plus any other fields that are of a cost type.

I attempted to create a formula for adding the custom fields:

= [Budget Capital - Hardware] + [Budget Capital - Software]

but Project displays Error

How do I display the full cost of the project?

 

[Jan De Messemaeker]

Hi,

Try building on this:

Sub ....
Dim Job as task

For each job in activeproject.tasks
if not job is nothing then
job.cost7=0
if not job.summary then
job.cost7=job.cost+job.cost1+job.cost2
end if
job.outlineparent.cost7=job.outlineparent.cost7+job.cost7
end if
next job

end sub

(Untested!!)

Greetings,


--
Jan De Messemaeker
Microsoft Project MVP
http://users.online.be/prom-ade

I know VBA, but I need a little push in the right direction.

Where would I find a sample of code to complete what you recommended.

Hi,

Formulas will not help you, since they can only be used in custom fields
and
Cost is not one.
You might put a formula in say Cost7 to say Cost+Cost1 etc.
If you know VBA, you can add your own fields to task's fixed cost, which
in
turn is added to Cost by Project.
Hope this helps,


--
Jan De Messemaeker
Microsoft Project MVP
http://users.online.be/prom-ade

I have created 6 Enterprise Custom Fields for tracking expense and
capital
costs.

When I enter a value into the fields, the Cost field for the project is
not
increasing. The cost field is only displaying the cost for the
resources,
not for the resource plus any other fields that are of a cost type.

I attempted to create a formula for adding the custom fields:

= [Budget Capital - Hardware] + [Budget Capital - Software]

but Project displays Error

How do I display the full cost of the project?