To make the formula work on summary tasks involves just a couple of mouse
clicks.
Right click on your custom column, select Customize Fields.
In the dialog that opens look towards the bottom for "Calculation for
task
and group summary rows" it is immediately below where you selected
"Formula".
Select a check box. The default is "none" which is why no calculation
shows
for you. Try using "Use Formula." If that is not to your liking, you
can
use teh "rollup" and select a different value.
--
If this post was helpful, please consider rating it.
Jim
Visit
http://project.mvps.org/ for FAQs and more information
about Microsoft Project
:
Hi Jim,
I tried making a custom field as you wrote below and entered the
formula
[Finish]-[Status Date], it will indeed give me the remainig duration
left but
only on the child or sub-tasks, it will show nothing/blank for the
summary
task. How come?
Thanks.
:
Hide the Remaining Duration colum and tell the customer you plan to
finish on
schedule.
You could insert one of the custom duration columns, rename it
Remaining
Duration and then apply a formula to get what you want.
I think this formula would be helpful: [Finish]-[Status Date] or
today's
date. You would also need to apply the same formula to the summary
rows.
Might you be able to use a remaining Work column instead? If you
want to
force the remaining duration to 10 days at the summary level, you
will need
to change the actual duration for the completed task. You would have
to hide
that column or explain the discrepancy.
I see your point on the remaining duration, however, the software is
performing as specified and is providing a correct answer.
Personally, I'd talk to it and show them what the help says for
remaining
duration calculation.
--
If this post was helpful, please consider rating it.
Jim
Visit
http://project.mvps.org/ for FAQs and more information
about Microsoft Project
:
Hi,
So MPP is not actually showing the logical picture of the summary
task. Task
A is already complete so MPP should calculate the remaining
duration of Task
B which is still ongoing.
If I show the summary task's remaining duration to my customer
whose finish
date will be on 14-Sept, he won't believe that the duration is
still 20days
left, it should be 10days left. Any idea?
:
Project calculates %Complete based on a linear interpretation of
the duration
of each task. Note the %Complete is 33%... you are one third of
the way
through your 30 day duration. If you are 33% complete, you have
66% of yoru
duration left ahead of you--- 20 days.
If you type a value in the Actual Duration field or % Complete
field,
remaining duration is calculated using the following formulas:
Remaining Duration = Duration - Actual Duration
Remaining Duration = Duration - (Duration * Percent Complete)
If you type a value in the Remaining Duration field, Microsoft
Office
Project calculates a new duration and completion percentage. If
you increase
or decrease remaining duration, Project changes duration to match
the sum of
the remaining duration and actual duration and leaves the actual
duration
unchanged.
--
If this post was helpful, please consider rating it.
Jim
Visit
http://project.mvps.org/ for FAQs and more information
about Microsoft Project
:
Hi,
I have an issue on the remaining duration. I hope somebody can
help me asap:
NAME % Comp Actual Duration Duration Remaining Duration Start
Finish
Summary Task 33% 10 days 30 days 20 days 06-Aug-07 14-Sep-07
Chilld task A 100% 5 days 5 days 0 days 06-Aug-07 10-Aug-07
Chilld task B 0% 0 days 10 days 10 days 03-Sep-07 14-Sep-07
Assuming today is 3-Sep, clearly the remaining duration SHOULD
be only 10
days left. How come in the summary task it is showing 20 days
left?? How to
make it exactly 10days left?
The problem is, only the summary task is shown to my customer
and when he
sees that the target finish date is 14-Sep, counting from 3-Sep
there should
be 10days left. But MPP is showing 20days left! Help!!!
Thanks.
