Project Plan - % complete and Planned % Complete Data Not Aligned
I would like some help please ! ...Our project templates are set up with 2 columns :
-% Complete (Input)
- % Planned Complete (Formula Driven)
In the example below, the % completion of the underlying tasks are the same value for both columns (aligned) ... yet the Parent task % complete is different, I am expecting the same value to be the same on the parent cell (highlighted in Orange)... any ideas why this could be ?
Formula for Planned % Complete :
"=ROUND(IF(TODAY() < [Start Date]@row, 0, IF(TODAY() >= [End Date]@row, 1, NETWORKDAYS([Start Date]@row, TODAY()) / NETWORKDAYS([Start Date]@row, [End Date]@row))), 2) "
Appreciate any insights !
Help Article Resources
Check out the Formula Handbook template!