Hello,

I'm new to FMP, and would like guidance on the following:

I am working with a database created by someone else, that contains a list of patient names.

In browse mode there is a field called "Team," and in setting the value for this field, it has been set up such that when you click on the box, it has two options: "Team A" and "Team B" to which you can set the value. This allows you to assign a team to each patient.

I would like to create another field, say "Team A total" in layout mode, that would sum the total number of "Team A" values for all of the patients in the "Team" field, and then another field "Team B total" to do the same for all of the "Team B" patients in the "Team" field. This way we can keep track of the total number of patients assigned to each team.

After spending a few hours on this (remember I am brand new to FMP) I can't figure out how to make it work. Any help would be greatly appreciated.

You will need two calcualtion fields

Case( Team = "Team A"; 1)

Case( Team = "Team B"; 1)

Then two summary fields that total each of the two fields above.

Thanks! It works perfectly now.