# simple weight of tasks - not by duration

• ### Question

• i would like % complete to be rolled up / computed by a weight assigned to each task, not duration.

simple example:

i am paid \$100,000 total for a contract.

the contract consists of two sub tasks, \$50,000 each.

the tasks have different duration amount.

i would like to be able to enter a completion % for each sub task, and have the main task be figured by \$ percentage instead of duration.

i am the only resource, and am looking for the simplest solution.

thanks

Monday, August 20, 2012 12:37 PM

• Hi,

As said, I suppose the ask cost is in the Cost field

Greetings,

Monday, August 20, 2012 5:25 PM

### All replies

• Hi,

Let's see if this suits you.

Insert 3 custom Fields

Number1, rename as input pct comp (for instance)

Number 2 rename as Calculated % comp

Cost1 rename as Completed Cost

and I suppose total cost for the task is in the cost field

Then do the following customizations ( formula)

Cost1 = Cost * Number1 / 100

for summary rows, use Sum

Number2 = 100*Cost1/Cost

For Summary Rows, use formula

Greetings,

Monday, August 20, 2012 12:58 PM
• sorry, i am lost after renaming the fields.
Monday, August 20, 2012 3:08 PM
• Hi,

So you never used a formula in Project? Let's try to go ahead

I suppose you're in the Customize Fields form since you say you renamed the fields.

When the cost1 field selected, click the word formula

In the formula window write [Cost]*[Number1]/100

OK

When back in the Custom Fields form, below Calculation for Task and Group Summary rows select Sum

Analogous for Number2

Greetings,

Monday, August 20, 2012 4:31 PM
• ok i believe that is done. now what am i supposed to do with the new fields?
Monday, August 20, 2012 4:54 PM
• Hi,

As said, I suppose the ask cost is in the Cost field