Project Compliance for tasks due up to Today
Hello, I am trying to figure out a way to gauge Project Compliance up to Today's date. What percentage of tasks are 100% complete that were due on or before today. In the example the compliance would be 75%. 4 tasks were due prior to today's date and 3 are marked 100%. Task 5 does not figure in because due date is in the future. I have a fairly complex project template with different departments in the parent rows. I would like to figure compliance by each department based on the child rows for that department.
Help Article Resources
Check out the Formula Handbook template!