Quick Links

Reply To: Expected % Complete

Home Forums Discussion Expected % Complete Reply To: Expected % Complete

Timothy Jones

Not sure if this helps with your question Jayakumar, but I wrote this formula to return the “% Should Be Complete” to flag activities that have not been updated to the status date. The formula shows the % that should be complete as of the status date. Then I compare that to the (actual) % Complete field to identify activities that need status update.

IIf([Scheduled Finish]<[Status Date],”100″,IIf([Scheduled Start]<[Status Date] And [Scheduled Finish]>=[Status Date],Round((ProjdateDiff([Scheduled Start],[Status Date])/[Scheduled Duration])*100,0),0))

This helps me in a large schedule to quickly see activities that are not at their expected % complete value.