AnsweredAssumed Answered

Sum Calculation in Filtered Portal

Question asked by AmandaBurch on Feb 29, 2012
Latest reply on Mar 1, 2012 by philmodjunk


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.