I have a Job Table connected By Job Id to both an invoice and an expenses table.
The Invoices and expenses have daughter line items. The Summary fields in each Invoice and expenses table correctly total the respective portals in the Jobs Layout.
My Problem is I cannot seem to be able to Sum the difference between the summary subtotals in the Job Layout. I have tried to make a calculation and a summary field pointing to the calculation in the Jobs table. Both do not work. they seem to total for each customer even though I am using TO's with single Job ID joins. The Jobs table has been sorted by Job ID. The summary fields in the Invoices and Expenses tables correctly summarize in the Jobs layout.
Could you help please.
Looking through past discussions found a message from Ray which says to use the aggregate functions. This worked. Thanks Ray