I have to create a report to show the percentage of pupils excluded from schools in their ethnic groups. The first group is on the school with a distinct count to show how many are registered at the school. The next group is Ethnic Origin and there is a distinct count on the pupil Id to show how many pupils in each ethnic group and a formula to show the percentage of pupils in each ethnic group. I have the exclusions table linked and I can count how many exclusions there have been in each ethnic group. What I need to do is show the percentage of pupils excluded in this group. This is where I am hitting the problem. If for instance there are 2 Chinese pupils in the school and one has been excluded 6 times and the other none the percentage displays as 300%. This is because I am using the exclusion Id for the distinct count. If I try to use the pupil Id I simply get the count of the students in the group. Help. Can anyone work out a formula so that it only counts the pupil once and could you also tell me where it goes? I wonder if I need another group?
Learn something new every day
Red Flag Submitted
Thank you for helping keep Tek-Tips Forums free from inappropriate posts. The Tek-Tips staff will check this out and take appropriate action.
Reply To This Thread
Posting in the Tek-Tips forums is a member-only feature.