AnsweredAssumed Answered

Counting single occurrences (unique values)

Question asked by brendaha on Apr 6, 2016
Latest reply on Apr 6, 2016 by brendaha

I created a report that counts the number of classes a student would take in a given year.  While one necessary report tells me the classes the student took in the given year, I need another report that gives me the total number of attendees for a given year.  Right now, my report shows duplicates thus if Alfred Hitchcock took two classes in 2015, it would my report lists his name twice thus the summary includes one extra number which should not be there.

 

I am extremely new to FileMaker Pro 13 and admit I don't know much about calculations or scripts.  Could someone in the community provide a detailed step-by-step process that would result in a count of unique values such that students taking two classes in a given year would only be counted once for that year, please?  I may have bitten off more than I can chew with my limited knowledge of the program, but a database with this capability is due in two weeks.

 

Please help!!!

Outcomes