Summary fields and portals
I've been beating my head against the wall for the last few hours with this problem. I am trying to figure out how to show a sum of all the hours worked by a person in a timesheet. I am able to summarize entire fields using the SUM() command (rather than running an actual summary field) but I have no luck with any of the commands when trying to summarize in a portal.
Relevant table descriptions:
Timesheet - Time info for every employee is stored here
Employee Listing - List of employees
Here's my table setup:
Overlord -> Timesheet -> Employee Listing -> Timesheet 2
The relationships are as follows:
Overlord --SelectedDate---> Timesheet --EmployeeID--> Employee Listing --SelectedDate---> Timesheet 2
I have a layout based on Overlord and a portal that is based on Employee Listing which shows the filtered out employees but the summary field(Based on a SUM() function that sums up the hours in Timesheet 2) shows the total for all employees rather than each individuals ones.
I've tried changing them to summary fields but those only show the first entry in each timesheet.
What should I be doing?