Add Decimal Places to Microsoft Project % Complete
I recently joined the MSOfficeForums Project forum, an online forum for posting Microsoft Project problems and one of the questions I answered on the forum was “how to show project summary task percent complete as a number with decimals”.
I have now recorded a short video tutorial outlining the steps to follow using Custom Fields to display Microsoft Project tasks % Complete with decimal places.
The formula used in this tutorial is shown below
% (Text1)
Formula = IIf([Actual Duration]=0,"0.00%",Format([Actual Duration]/[Duration]*100,"#.00") & "%")
Calculation for task and group summary row, tick “Use formula”