Rolling 12-months formula: % of projects completed on time
I am looking for a formula that will calculate the % of projects completed on time when the actual complete date is on or before the scheduled complete over a rolling 12-month period and the Project Status is Completed. The rolling 12-months will be based on the Actual Complete Date column. Below is is the data. So for the data below it should return a value of 70% because 7 of 10 projects had an actual complete date on or before the scheduled complete date.