Jump to content

Newbie question on calculating


This topic is 5712 days old. Please don't post here. Open a new topic instead.

Recommended Posts

  • Newbies

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.

Link to comment
Share on other sites

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.

Link to comment
Share on other sites

This topic is 5712 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.