AnsweredAssumed Answered

Total one field in specific records during a time period

Question asked by WalterBarrueto on Sep 22, 2011
Latest reply on Sep 22, 2011 by philmodjunk

Title

Total one field in specific records during a time period

Post

FMP 10 on PC and Mac

Employees log their time in FMP.  There is one table that has all of the fields to log their time for each day of the pay period.  This table is called "time".  Each employee has one record and then a new record is made for the pay period.  So if there are 10 employees and we are in week 26 of the year, there are 260 records in this table.

A supervisor can monitor the totals of the current pay period in another table called "TimeTotals".  One record is made in this table for each pay period.  Each record contains the name of each employee and the total hours and other information that are specific for just that pay period.  Using the previous example, there are 10 employees and we are in week 26 of the year, there are only 26 records in this table.  All of the information in each record is specific to just the pay period of that record.

Hopefully that all makes sense.  How can I easily add a new calculation where I total information for each employee, but the total will only include information from January 1 of the current year to today?  For example, I want to total personal time for each employee starting from January 1 of this year to today.  How would I go about writing a calculation to receive this information?

Outcomes