AnsweredAssumed Answered

FMP - Collapsing multiple records into one, and summing

Question asked by soonershawnee on Sep 24, 2018
Latest reply on Sep 24, 2018 by philmodjunk

I have multiple records in my DB that I want to "collapse" into one record and sum their contents. Specifically, I have a DB of every state school and each of the class periods for that school (along with the enrollment number in each period). However, I don't want to show 6 different class periods of English for each school with 30 students in each period, but want to collapse it down to show just one English class, and have enrollment shown as 150.

 

I haven't been able to find a solution online for this - and I'm a relative newcomer to FMP.

 

Thanks.

****

Here's a Google spreadsheet showing an example of the data - and the example data is below.

Example for FMP - Google Sheets

 

CURRENT DATABASE
SchoolCITYCourse NameCourse CodeEnrollment
Mt. Eden HighHaywardWelding82312
Mt. Eden HighHaywardWelding82312
Tennyson HighHaywardWelding82311
San Leandro HighSan LeandroMachining82213
San Leandro HighSan LeandroMachining822128
San Leandro HighSan LeandroMachining82213
San Leandro HighSan LeandroCarpentry900030
San Leandro HighSan LeandroCarpentry900030
I want to look at the School & the Course Code, and for those that are the same on those criteria, "COLLAPSE" it to just show that class once for that high school, with the enrollment number added together
SchoolCITYCourse NameCourse CodeEnrollment
Mt. Eden HighHaywardWelding82314
Tennyson HighHaywardWelding82311
San Leandro HighSan LeandroMachining822134
San Leandro HighSan LeandroCarpentry900060

Outcomes