Calculate % Complet

R

René

Hi All,

quick question: is there a way to calculate percantage complete from a custom field?

I have a field which holds the number of testconditions and would like to calculate the % Complete by entering the number of successfully tested conditions...

Any suggestions?

Thx,
René
 
S

Steve House

That's not percent complete. In Project, the "% Complete" field refers to
duration. There's also "% Work Complete" which refers to man-hours. The
field that corresponds to your testing is the "Physical % Complete" field
and populating it is a manual process.

--
Steve House
MS Project MVP
Visit http://www.mvps.org/project/faqs.htm for the FAQs


René said:
Hi All,

quick question: is there a way to calculate percantage complete from a custom field?

I have a field which holds the number of testconditions and would like to
calculate the % Complete by entering the number of successfully tested
conditions...
 
D

Dean Carroll

René
In case you still need an answer:
If you want to display a number in a table field or on the Gantt chart, use a number field; otherwise, replace [Number3] in the formula for Finish1 with the right side of the formula for [Number3] :
Calculated %([Number3]) = successfully tested conditions([Number1] )/ Total number of test conditions ([Number2] )
Finish1 = ProjDateAdd( [Actual Start] , [Duration] * [Number3] )
Create a custom Gantt bar for progress with Finish1 in the "to" column. Use a Flag field to set applicability for using this progress instead of % complete.

If all tasks under a summary task are the same, [Number1] and [Number2] can rollup the sum to the summary row and [Number3] and Finish1 can use the formula for the summary row. If there is a mixture, copy the calculated % to % complete and don't bother with modifying the Gantt bar.
----- René wrote: -----

Hi All,

quick question: is there a way to calculate percantage complete from a custom field?

I have a field which holds the number of testconditions and would like to calculate the % Complete by entering the number of successfully tested conditions...

Any suggestions?

Thx,
René
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top