Jump to content

calculate a sum of a field according to another field


MissT
 Share

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

Recommended Posts

  • Newbies

Hi

I have a database where i need the total activity time of a staff member but adding only the records where the staff's time allocation equals "stage 1".

When the staff member enters in there activity time, they enter in what stage it was aswell. So in another database i want to show the total activity time the staff member has done according what stage field equals.

There is a activity database, staff database and management database.

Basically how do you calculate a total sum of a field but only where another field = x?

Sorry if this is not understandable, i'm a newbie to filemaker.

Also this is in FM6.

Link to comment
Share on other sites

You can have a calc field with ( Case Staff::timeallocation = "stage 1"; 1 ) and then add the total of that field either through a summary field or calculation from the parent side using the sum function.

Link to comment
Share on other sites

This topic is 5700 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.