Employee Database

Discussion created by rbergerj on Feb 27, 2017
Latest reply on Feb 28, 2017 by MichaelManousos



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!