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.

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.