How to get the Percentage of Special Ed Students in the District/School:
Run the following query, add the Totals, and then divide by the Total Special Ed
TOTAL STU SPECIALED BY SPECIALED
Results:
No - 9318
Yes - 697
Add the numbers to get a Total: 10,015
Ten Divide by the number of Special Ed: 697
The percentage in the above example would be 14.37%