Sum Calculation in Filtered Portal
I have a portal on Employee Scheduling (table) displaying individual line items--or Projects (table)--via a Employee ID relationship. I have a filter set up to restrict portal results by selecting a Month and would now like to set up a calculation to sum the percent of allocation (field) per project with the filter in place. For example, an emloyee has two projects in the portal--one at 40% and the other at 25% in the month of April. I can get the caluclation to work when all line items are viewed in the portal, but not when filtering by month.