AnsweredAssumed Answered

List of active employee and total days of absent

Question asked by WeirdMan on Jul 24, 2013
Latest reply on Nov 9, 2013 by WeirdMan

Title

List of active employee and total days of absent

Post

     Hi, I am currently working for a salary database solution. I am looking to show a list of active employee with count of absent day in a specified date range.

     I have employee table with resigned field (boolean value), daily transaction table for working hour and work category. Absent is in working category value list. So the way to seek if an employee is absent in a specified date is to check their working category on that day.

     I tried to use solution from this thread: http://forums.filemaker.com/posts/5851b45723 with addition that I create a calculation field (absent) in daily transaction table with this formula < If (ID_Category = absent ; 1 ; 0 ) > and a summary field < total of absent>. I use relationship as attached (karyawan is employee in Indonesian language), and the summary result is total of all absent category from all employee

     What do I miss? How to get it work?

Screen_Shot_2013-07-24_at_18.49.42.png

Outcomes