Adding subtotals from portal rows
I have a pricing layout for jobs. There are multiple departments that may contribute to the job so I set up a separate table with a portal to the pricing table. I have it set up so that a new record is created as a department number and numbers are added and the department total is caculated at the bottom of each portal "row". ( I actually set up four separate portals with each one showing the next row to show them horizontally). Now I am trying to get a GrandTotal field in the Job table to show the sum of the DepartmentTotals and it isn't working. I'm sure I am missing something simple.