Microsoft KB Archive/321669

= How to display progress that is based on the &quot;Physical Percent (%) Complete&quot; field in Microsoft Project 2002 =

Article ID: 321669

Article Last Modified on 1/7/2006

-

APPLIES TO


 * Microsoft Project 2002 Standard Edition
 * Microsoft Project 2002 Professional Edition

-



This article was previously published under Q321669





For a Microsoft Project 2003 version of this article, see 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.</li> On the Format menu, click Bar Styles.</li> Create a bar style with the From value of Start, and the To value of Finish1.

For example, follow these steps: <ol style="list-style-type: lower-alpha;"> Click a new blank cell in the Name column, and then type test progress .</li> Click the Appearance column of the test progress row.

A shaded bar appears.</li> Click the '''Show For ... Tasks column, and then click Normal''' in the list.</li> Click the From column of this same row, and then click Start in the list.</li> Click the To column of this same row, and then click Finish1 in the list.</li></ol> </li> Click OK.</li></ol>

<div class="status_section">

STATUS
Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.

<div class="moreinformation_section">

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.

Keywords: kbpending KB321669

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.