Jump to content

Calculations in Sub-Summary Part


John May
 Share

This topic is 6488 days old. Please don't post here. Open a new topic instead.

Recommended Posts

I have what I thought was a pretty simple task, but it didn't quite work.

I work for a school district. One of the schools gave me a file of course and grade data. They wanted to know "what percent of students passed each course?

I created a calculated Case field (Pass Calc) to determine if the the grade was "passing" or not (if passing, "1", otherwise "0"). Then I created a summary field (Total Pass) to sum Pass Calc. I also have a summary field to count the number in each course (Class Count).

The layout has only a sub-summary part (when sorted by Course Name). In that part I have Course Name, Total Pass, Class Count. This works fine.

The problem arose when I tried to calculate the percent passed for each class by simply dividing Total Pass by Class Count in the same sub-summary line. Instead of getting the percent for each class, I got the total percent for the entire population.

Picture of Layout and Previewed page attached.

Shouldn't I be able to calculate this? What have I done structurally wrong?

FileMaker Version: 6

Platform: Mac OS 9

SubSummaryCalc.pdf

Link to comment
Share on other sites

You want to use the GetSummary function. Using summary fields in a calculation like that will give you a result based on every record in the found set. Try something like GetSummary( TotalPass, Course ) / GetSummary( TotalInClass, Course ) and format it as a percentage.

Link to comment
Share on other sites

This topic is 6488 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.