formula

[CAYPOH]

The problem looks like this:
I am planning budget and enter cost fo several tasks. I have also phases
that include some of tasks and summarize the costs of its subtasks.
everything's good except 1 thing - i need 10% "reserve" of total cost of each
phase. Creating another column like = cost*1.1 is not good.

so how can i get the following:

Phase cost = cost1+cost2+cost3
task1 cost1
task2 cost2
reserve cost3=(cost1+cost2)*10%

or something that will work the same.

Thanks in advance

 

[Catfish Hunter]

Not sure of what you need so here is a suggestion. You can customize text
fields with a formulia. There are 30 text fields or you can use the cost
fields. Go to tools, customize, fields. Chose the type of field. You can add
a formula like you have in your original question. Not sure if this helps,
good luck.

 

[JulieS]

Hi CAYPOH,

The difficulty is that custom fields can only reference other fields on
the same task. So creating the "reserve" task which adds the costs from
Task 1 & Task 2 is not possible.

You note that having a field multiplying task cost by 1.1 is "not good"
but it is the only work around I can come up with. Insert the Cost1
field into a view and use that to record the costs for each task. In
the customize field dialog box, set the calculation for the summary task
to Sum. Add another custom cost field (Cost 2) and set its formula to
[Cost1]*1.1 and set the summary task calculation to Sum.

The only other work around would be to export the data to Excel, write
the formulas in Excel and paste link the result of the formula into the
summary custom cost field. Please note that paste links are notorious
for corruption and each summary cost would need to be individually
linked.

--
I hope this helps. Let us know how you get along.

Julie

Visit http://project.mvps.org/ for FAQs and more information about
Microsoft Project.

 

[Catfish Hunter]

I can only make this work within a task but not between task. It can be
exported to Excel.

Hi CAYPOH,

The difficulty is that custom fields can only reference other fields on
the same task. So creating the "reserve" task which adds the costs from
Task 1 & Task 2 is not possible.

You note that having a field multiplying task cost by 1.1 is "not good"
but it is the only work around I can come up with. Insert the Cost1
field into a view and use that to record the costs for each task. In
the customize field dialog box, set the calculation for the summary task
to Sum. Add another custom cost field (Cost 2) and set its formula to
[Cost1]*1.1 and set the summary task calculation to Sum.

The only other work around would be to export the data to Excel, write
the formulas in Excel and paste link the result of the formula into the
summary custom cost field. Please note that paste links are notorious
for corruption and each summary cost would need to be individually
linked.

--
I hope this helps. Let us know how you get along.

Julie

Visit http://project.mvps.org/ for FAQs and more information about
Microsoft Project.

The problem looks like this:
I am planning budget and enter cost fo several tasks. I have also
phases
that include some of tasks and summarize the costs of its subtasks.
everything's good except 1 thing - i need 10% "reserve" of total cost
of each
phase. Creating another column like = cost*1.1 is not good.

so how can i get the following:

Phase cost = cost1+cost2+cost3
task1 cost1
task2 cost2
reserve cost3=(cost1+cost2)*10%

or something that will work the same.

Thanks in advance

 

[JulieS]

Catfish,

The summary task line shows the sum of the subtasks, which is what I
think CAYPOH was searching for.

Julie

I can only make this work within a task but not between task. It can be
exported to Excel.

Hi CAYPOH,

The difficulty is that custom fields can only reference other fields
on
the same task. So creating the "reserve" task which adds the costs
from
Task 1 & Task 2 is not possible.

You note that having a field multiplying task cost by 1.1 is "not
good"
but it is the only work around I can come up with. Insert the Cost1
field into a view and use that to record the costs for each task. In
the customize field dialog box, set the calculation for the summary
task
to Sum. Add another custom cost field (Cost 2) and set its formula
to
[Cost1]*1.1 and set the summary task calculation to Sum.

The only other work around would be to export the data to Excel,
write
the formulas in Excel and paste link the result of the formula into
the
summary custom cost field. Please note that paste links are
notorious
for corruption and each summary cost would need to be individually
linked.

--
I hope this helps. Let us know how you get along.

Julie

Visit http://project.mvps.org/ for FAQs and more information about
Microsoft Project.

The problem looks like this:
I am planning budget and enter cost fo several tasks. I have also
phases
that include some of tasks and summarize the costs of its subtasks.
everything's good except 1 thing - i need 10% "reserve" of total
cost
of each
phase. Creating another column like = cost*1.1 is not good.

so how can i get the following:

Phase cost = cost1+cost2+cost3
task1 cost1
task2 cost2
reserve cost3=(cost1+cost2)*10%

or something that will work the same.

Thanks in advance

 

[Catfish Hunter]

I built a 1 task schedule and made everything work but the cost would no sum
up on the summary task???

Catfish,

The summary task line shows the sum of the subtasks, which is what I
think CAYPOH was searching for.

Julie

I can only make this work within a task but not between task. It can be
exported to Excel.

Hi CAYPOH,

The difficulty is that custom fields can only reference other fields
on
the same task. So creating the "reserve" task which adds the costs
from
Task 1 & Task 2 is not possible.

You note that having a field multiplying task cost by 1.1 is "not
good"
but it is the only work around I can come up with. Insert the Cost1
field into a view and use that to record the costs for each task. In
the customize field dialog box, set the calculation for the summary
task
to Sum. Add another custom cost field (Cost 2) and set its formula
to
[Cost1]*1.1 and set the summary task calculation to Sum.

The only other work around would be to export the data to Excel,
write
the formulas in Excel and paste link the result of the formula into
the
summary custom cost field. Please note that paste links are
notorious
for corruption and each summary cost would need to be individually
linked.

--
I hope this helps. Let us know how you get along.

Julie

Visit http://project.mvps.org/ for FAQs and more information about
Microsoft Project.

The problem looks like this:
I am planning budget and enter cost fo several tasks. I have also
phases
that include some of tasks and summarize the costs of its subtasks.
everything's good except 1 thing - i need 10% "reserve" of total
cost
of each
phase. Creating another column like = cost*1.1 is not good.

so how can i get the following:

Phase cost = cost1+cost2+cost3
task1 cost1
task2 cost2
reserve cost3=(cost1+cost2)*10%

or something that will work the same.

Thanks in advance

 

[Jan De Messemaeker]

Hi,

Have you done also what Julie asked for in her first post:

In
Greetings,

--
Jan De Messemaeker, Microsoft Project Most Valuable Professional
http://users.online.be/prom-ade/
For FAQs: http://www.mvps.org/project/faqs.htm

I built a 1 task schedule and made everything work but the cost would no sum
up on the summary task???

Catfish,

The summary task line shows the sum of the subtasks, which is what I
think CAYPOH was searching for.

Julie

I can only make this work within a task but not between task. It can be
exported to Excel.

:

Hi CAYPOH,

The difficulty is that custom fields can only reference other fields
on
the same task. So creating the "reserve" task which adds the costs
from
Task 1 & Task 2 is not possible.

You note that having a field multiplying task cost by 1.1 is "not
good"
but it is the only work around I can come up with. Insert the Cost1
field into a view and use that to record the costs for each task. In
the customize field dialog box, set the calculation for the summary
task
to Sum. Add another custom cost field (Cost 2) and set its formula
to
[Cost1]*1.1 and set the summary task calculation to Sum.

The only other work around would be to export the data to Excel,
write
the formulas in Excel and paste link the result of the formula into
the
summary custom cost field. Please note that paste links are
notorious
for corruption and each summary cost would need to be individually
linked.

--
I hope this helps. Let us know how you get along.

Julie

Visit http://project.mvps.org/ for FAQs and more information about
Microsoft Project.

The problem looks like this:
I am planning budget and enter cost fo several tasks. I have also
phases
that include some of tasks and summarize the costs of its subtasks.
everything's good except 1 thing - i need 10% "reserve" of total
cost
of each
phase. Creating another column like = cost*1.1 is not good.

so how can i get the following:

Phase cost = cost1+cost2+cost3
task1 cost1
task2 cost2
reserve cost3=(cost1+cost2)*10%

or something that will work the same.

Thanks in advance

 

[JulieS]

In the Customize Fields dialog box, set the calculation for task and
group summary rows to Rollup: Sum.

Julie

Visit http://project.mvps.org/ for FAQs and more information about
Microsoft Project.

I built a 1 task schedule and made everything work but the cost would
no sum
up on the summary task???

Catfish,

The summary task line shows the sum of the subtasks, which is what I
think CAYPOH was searching for.

Julie

I can only make this work within a task but not between task. It can
be
exported to Excel.

:

Hi CAYPOH,

The difficulty is that custom fields can only reference other
fields
on
the same task. So creating the "reserve" task which adds the
costs
from
Task 1 & Task 2 is not possible.

You note that having a field multiplying task cost by 1.1 is "not
good"
but it is the only work around I can come up with. Insert the
Cost1
field into a view and use that to record the costs for each task.
In
the customize field dialog box, set the calculation for the
summary
task
to Sum. Add another custom cost field (Cost 2) and set its
formula
to
[Cost1]*1.1 and set the summary task calculation to Sum.

The only other work around would be to export the data to Excel,
write
the formulas in Excel and paste link the result of the formula
into
the
summary custom cost field. Please note that paste links are
notorious
for corruption and each summary cost would need to be individually
linked.

--
I hope this helps. Let us know how you get along.

Julie

Visit http://project.mvps.org/ for FAQs and more information about
Microsoft Project.

The problem looks like this:
I am planning budget and enter cost fo several tasks. I have
also
phases
that include some of tasks and summarize the costs of its
subtasks.
everything's good except 1 thing - i need 10% "reserve" of total
cost
of each
phase. Creating another column like = cost*1.1 is not good.

so how can i get the following:

Phase cost = cost1+cost2+cost3
task1 cost1
task2 cost2
reserve cost3=(cost1+cost2)*10%

or something that will work the same.

Thanks in advance

 

[Catfish Hunter]

Mummmmmmmm, Guess I missed the roll up button. Hate when that happems.

Hi,

Have you done also what Julie asked for in her first post:

In
Greetings,

--
Jan De Messemaeker, Microsoft Project Most Valuable Professional
http://users.online.be/prom-ade/
For FAQs: http://www.mvps.org/project/faqs.htm

I built a 1 task schedule and made everything work but the cost would no sum
up on the summary task???

Catfish,

The summary task line shows the sum of the subtasks, which is what I
think CAYPOH was searching for.

Julie

message I can only make this work within a task but not between task. It can be
exported to Excel.

:

Hi CAYPOH,

The difficulty is that custom fields can only reference other fields
on
the same task. So creating the "reserve" task which adds the costs
from
Task 1 & Task 2 is not possible.

You note that having a field multiplying task cost by 1.1 is "not
good"
but it is the only work around I can come up with. Insert the Cost1
field into a view and use that to record the costs for each task. In
the customize field dialog box, set the calculation for the summary
task
to Sum. Add another custom cost field (Cost 2) and set its formula
to
[Cost1]*1.1 and set the summary task calculation to Sum.

The only other work around would be to export the data to Excel,
write
the formulas in Excel and paste link the result of the formula into
the
summary custom cost field. Please note that paste links are
notorious
for corruption and each summary cost would need to be individually
linked.

--
I hope this helps. Let us know how you get along.

Julie

Visit http://project.mvps.org/ for FAQs and more information about
Microsoft Project.

The problem looks like this:
I am planning budget and enter cost fo several tasks. I have also
phases
that include some of tasks and summarize the costs of its subtasks.
everything's good except 1 thing - i need 10% "reserve" of total
cost
of each
phase. Creating another column like = cost*1.1 is not good.

so how can i get the following:

Phase cost = cost1+cost2+cost3
task1 cost1
task2 cost2
reserve cost3=(cost1+cost2)*10%

or something that will work the same.

Thanks in advance