I set up a new "On time" function, which should give you a little more control of how you would like to deal with the "null" completion date. I also built a completion rate function and dropped it into a crosstab. I think this catches all of your requirements and should at least get you going with the data. Let me know if you have any questions and I will try and answer best I can.
Have a great Tuesday,
Edit: I tend to go to numbers rather than phrases, 1 for on time, and 0 for late. Someday, I will be good enough to remember all of the silly details before I hit the reply button. I put incomplete tasks on a filter to switch between pending tasks and what is already completed. Catching tasks which are on the edge of being late for prioritizing might be somewhat messy, but it gets close..
AvgDates_CCC.twbx 23.1 KB
Thanks Chris. This was exactly what I needed. I also very much appreciate the fast response!