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)

  1. Formula = IIf([Actual Duration]=0,"0.00%",Format([Actual Duration]/[Duration]*100,"#.00") & "%")

  2. Calculation for task and group summary row, tick “Use formula”

Previous
Previous

Baseline Execution Index (BEI) in Microsoft Project

Next
Next

7 Tips for Effective Power BI Dashboards