AnsweredAssumed Answered

Summary fields and portals

Question asked by ahcho on Jul 23, 2015
Latest reply on Jul 23, 2015 by philmodjunk

Title

Summary fields and portals

Post

Hello!

 

 

 

 

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

              --SelectedProject->                                                                              --SelectedProject->

               --EmployeeID-->

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?

Aaron

Outcomes