Microsoft Knowledge Base Article
This article contents is Microsoft Copyrighted material.
©2005-©2007 Microsoft Corporation. All rights reserved.
Terms
of Use |
Trademarks
Article ID: 321669 - Last Review: January 7, 2006 - Revision: 3.2
How to display progress that is based on the "Physical Percent (%) Complete" field in Microsoft Project 2002
This article was previously published under Q321669
For a Microsoft Project 2003 version of this article, see
823469Â
(http://kbalertz.com/Feedback.aspx?kbNumber=823469/
)
.
SYMPTOMS
For tasks, you cannot display progress bars that are based on the Physical Percent (%) Complete field in Microsoft Project 2002.
CAUSE
Microsoft Project 2002 does not directly support a bar style definition that is based on the Physical % Complete field.
WORKAROUND
To work around this issue, calculate the date through which the progress is complete, and base the calculation on the Physical % Complete field. To do this, follow these steps:
- In the task view that you want (for example, the Gantt Chart view), click Column on the Insert menu.
- In the Field name list, click Finish1, and then click OK.
The Finish1 column is inserted into the current view. - Right-click Finish1, and then click Customize Fields.
- Click Formula, and then type the following formula in the Finish1= box: projdateadd([start],([physical % complete]/100)*[duration])
- Click OK, click OK to confirm the replacement of existing data in the Finish1 field with the new calculated values, and then click OK.
- On the Format menu, click Bar Styles.
- Create a bar style with the From value of Start, and the To value of Finish1.
For example, follow these steps:- Click a new blank cell in the Name column, and then type test progress.
- Click the Appearance column of the test progress row.
A shaded bar appears. - Click the Show For ... Tasks column, and then click Normal in the list.
- Click the From column of this same row, and then click Start in the list.
- Click the To column of this same row, and then click Finish1 in the list.
- Click OK.
STATUS
Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.
MORE INFORMATION
The Physical % Complete task field shows a percent complete value that you can use to calculate the budgeted cost of work performed (BCWP). This field is also named Earned Value % Complete.
For more information about how to use the Physical % Complete field in your projects, click
Microsoft Project Help on the
Help menu, type
earned value fields in the Office Assistant or
the Answer Wizard, and then click
Search to view the topics
returned.
APPLIES TO
- Microsoft Project 2002 Standard Edition
- Microsoft Project 2002 Professional Edition
Community Feedback System
Very often, it takes hours to solve a problem. Very often, you've looked high
and low, and have tried a lot of solutions. When you finally found it, chances
are, it was because someone else helped you. Here's your chance to give back.
Use our community feedback tool to let others know what worked for you and what
didn't.
Please also understand that the community feedback system is not warranted to be
correct, it's simply a system that we've built to let people try and help each
other. If something in a feedback response doesn't make sense to you, or you're
not comfortable making changes that the feedback talks about (like registry
edits), please consult a professional.
Thank you for using kbAlertz.com Feedback System.
-- Scott Cate
Be the first to leave feedback, to help others about this knowledge base
article.
(Optional) Name
(Optional)
Public URL Or Email
Comments
No
HTML -- Text Only Please