View Single Post
 
Old 09-28-2011, 06:32 AM
abw1987 abw1987 is offline Windows 7 32bit Office 2010 32bit
Novice
 
Join Date: Sep 2011
Location: Boston
Posts: 7
abw1987 is on a distinguished road
Default

Quote:
Originally Posted by OTPM View Post
Welcome to the forum.
Thanks!

Quote:
Originally Posted by OTPM View Post
First of all when you have task A as 5 days and task b as 10 days, and then mark task A as 100% complete the summary task DOES show 33% and NOT 50%, so not sure what your confusion is here.
Right. This is true of the standard % Complete field, but for a custom Text field I'm not sure how to do this. I want to be able to manually enter task completion percentages in the Text field, and have those values roll up to the summary tasks. However I don't want the values in this field to automatically update whenever I change the project Status Date. So a summary task percentage should be based solely on the manually-entered percentages, and the overall durations, of the tasks below it.

Quote:
Originally Posted by OTPM View Post
Second can you post what you have done so far so we can have a look in more detail.
Absolutely. Though I can't post the project plan I am working with (confidential), I have attached an example. In this example, you will notice two columns:
  • % Complete (Planned):
    This is just the standard % Complete field, which updates automatically whenever I go to Update Project and pick a new Status Date. This functions just how I would like it to. The current status date in the Project Plan is 9/30, so the tasks' % Complete values are automatically updated accordingly.
  • % Complete (Actual):
    This is a Text field, in which I have manually entered percentages at the task level. (As you can see, we are behind on Example Task 2.) I would like the percentages to roll up to the summary task. Is there a better field that would accomplish this? I want to make sure it doesn't automatically update the percentages whenever I go to Update Project and pick a new Status Date.
Does that all make sense?

Thanks!
Attached Files
File Type: zip ExampleProject.zip (24.6 KB, 76 views)

Last edited by abw1987; 09-28-2011 at 06:53 AM. Reason: Clarity
Reply With Quote