Invoice portal calculation issues
I am making an invoice database and I am having an issue figuring out a SUM function. I have a layout with the customer information. On this layout I put in a portal that will show me a list of unpaid invoices for that particular customer. The portal list appears to be working properly, showing me only the invoices for the current customer however I can not figure out how to make a summary box for the totals of all of the invoices in the portal.
I also made a portal for paid invoices and need to do the same summary for the paid invoices.
Any help is greatly appreciated.