Hello there,

 

I’m relatively new to filemaker and this forum, apologies if I'm posting in the wrong section or haven't searched older posts thoroughly enough.

 

I modified the personnel records database from a starter solution to track out payroll needs, and I’m having a difficult time getting a summary of hours over a current payroll period to generate in a PDF. 

 

I’ve tried creating a number field that I just manually enter for each record as a quick fix, and even that won’t generate on the PDF. Ideally this is a function that calculates employee hours over a time frame chosen by the user. 

 

Any help would be greatly appreciated.

I’ve tried creating a number field that I just manually enter for each record as a quick fix, and even that won’t generate on the PDF. Ideally this is a function that calculates employee hours over a time frame chosen by the user.

 

You can add a field of type summary = SumOf hours, which will return the total hours for the found set – which you can get at by performing a find based on the date range input by the user.

 

If you need hours by employee, create a layout with a sub-summary part that uses the employee name as break field. Place the summary field into the sub-summary part, and sort by employee name (sorting by break field is an essential step to get the correct results in a sub-summary).

 

Note that you can use the same summary field to display different results, based on the layout part it is in.

The Sum function worked perfectly for my needs, thank you for your help.