4 Replies Latest reply on Apr 18, 2011 8:30 AM by mgores

    Adding subtotals from portal rows

    mgores

      Title

      Adding subtotals from portal rows

      Post

      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.

      screenshot.jpg