Summary calculation help
I am very new to filemaker and I need some assistance summarizing data.
I am developing a database to be used to check students into the office (kind of like the "take a number" approach at the DMV).
The fields in question are "student ID number", "purpose" and "representative" - the last two are each fields that contain a list of values.
Basically, I want to count the number of students who come into the office for each representative in the list of values, and for each purpose in the list of values.
At this point, all I've managed to do is get a total count of the number of students logged into the database using a summary field.
I've tried setting up a field for each Rep, and used the following calculation, which is not working:
If (Rep="Mary" ; Count (StudentID) ; " " )
Any assistance is helpful at this point!
What you describe is called a summary report. If you use part setup to add a sub summary layout part to your layout, you can put your summary field inside this part and now this same field will show a sub total instead of a grand total provided that you correctly sort your records.
See here for a tutorial on summary reports: Creating Filemaker Pro summary reports--Tutorial