Totally the number of schools in a report
I am writing a report that gives me the number of students with special needs in a school district. I can find the total of students in each school district but I want to find the total number of schools. When I count the number of schools I get the same total as the number of students.
Even though there are 5 students from one school can I get the value of the school changed to 1 instead of 5.
So if I have 300 students in total I may have a total of 32 schools instead of 300.