Getting percentages in a sub-summary field

[dgroyal]

I've got a bunch of student records, which include nationality and a progression decision.  I would like to see the progression rate by nationality.

 

I've attached a screenshot of what I'm currently getting on a layout with sub-summaries sorted by nationality.

 

 

The # of students and the # of students progressed seem to be working.  These are both summary fields, with the progressed number being the total of a calculation that is 1 if they progress and 0 if they don't.  For the %, I have a numeric calculation field where I divide the two summary fields: (s_countStudentsProgressed / s_countStudents)

 

As you can see, the percentage I'm getting is that total overall progression rate, rather than the value in each sub-summary section.  What am I missing?  I can't use the "fraction of" summary field, because I don't want to know what percentage of our progressing students come from a certain country.  I want to know what percentage of students in a certain country progress.

 

Any help would be greatly appreciated.  And if you have any questions for me, please don't hesitate to ask.

 

Thanks!

Dave

[dgroyal]

Hi folks.

 

Nevermind, I figured it out.  For posterity, here's what I needed to do.  My percentage calculatio needed to be this: GetSummary ( s_countStudentsProgressed ; nationality ) / GetSummary ( s_countStudents ; nationality )

 

Thanks!

Dave

[Davesmind]

Thank you for updating your post as this was the same problem I was having.

 

[geraldh]

Thank you for this post. 

I was trying to figure out something similar.

 

I tried to use the principles of your solution, but I couldn't repurpose it figure out my problem.

 

I teach college classes with students in different years of their study.

 

I wish to find percentages of the students in each year out of the total class size.

 

Please my screenshot:

 

I've set up Sum Count fields to capture the Count of Students in each Year of Study and for the Class.

 

In the example. I have 19 students in the class. 3 student in Year 01; 7 students in Year 02, etc.

 

I wish to have percentages show up beside each the number of students in  each year.

 

I hope I am making sense, but please ask for clarification if it doesn't make sense.

 

Thank you.

[comment]

Assuming your records are sorted by Class and by Year, use =

GetSummary ( sCount ; Year ) / GetSummary ( sCount ; Class )

to get the number of students in each year as a fraction of the total number of students in that class. sCount is a summary field, counting any field of the Students table that cannot be empty.

[geraldh]

Thank you. Worked perfectly.