I'm relatively new to FileMaker Pro. I created a database to store employee information and organize employee files. Items such as reviews, training records and such. I want the database to also compute useful information like employee turnover and department headcount. I'm struggling with getting a field to calculate or summarize how many "active employees" or "active temps" in a specific department. I would ideally need a count(if) type function. Can anyone help me? I have 6-9 departments each have full time employees and temp hire employees. I want to create a headcount for those departments.
Any help or direction will help a lot!! Thank you!