Sum of payroll hours over a time period

[ryan1928]

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.

[eos]

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.

[ryan1928]

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