I have a three tables:
Both AppQuotesParts and AppQuotesItems have columns which calculate totals, VAT, Discount etc, they are both exactly the same in structure other than the table name.
I have a report which initially is based on Customers and pulls data from AppQuotesItems
<<Start: FILTER(“Appquotesitems”, AND([JobID]=[_THISROW].[JobID], [Status]=“Authorised”))>><<[Item]>>…and several other column data follows … this all works very well…
I can do the same for AppQuotesParts very easily:
<<Start: FILTER(“AppquotesParts”, AND([JobID]=[_THISROW].[JobID], [Status]=“Authorised”))>><<[Item]>>…etc
And here is wherethe problem lies.
How do i Sum the values of both on the same report ??