1 Reply Latest reply on Feb 26, 2015 7:06 AM by philmodjunk

    Summary calculation help

    JenStokes

      Title

      Summary calculation help

      Post

      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! 

       

      Thanks,

      Jen