Project: Multiplication of Costs and Constant

[GDB]

Hi,
This is the first time posting here so my question might be a bi
simple. When I export my project out in a Pivot chart, for a period,
need to be able to multiply the costs by a constant, but that constan
changes for each task?
For example:

task 1 takes 43 days and costs $2500
task 2 takes 57 days and costs $3800
task 3 takes 12 days and costs $800

Task 1 moves 50 tons of dirt per $1
Task 2 moves 55 tons of dirt per $1
Task 3 moves 100 tons of dirt per $1

When I do a pivot chart in periods of weeks, I need to know how ho
much it has cost me and how much dirt is moved

 

[Rob Schneider]

If you are doing the caculations in the Pivot chart (and associated
table), then you are doing your work in Excel. So this is really an
Excel question?

If I understand your situation, you can perhaps do this computation in
Project by defining a few custom task fields:

Number field [Dirt Cost], and for each task enter 50, 55, and 100
Number field [Dirt Moved] (is it related to the cost of the task?
Cost Field computed, [Dirt Cost]=[Dirt Moved]*[Dirt Cost]

Project's Help explains how to do these custom fields.

--rms

www.rmschneider.com