Trying to create a total sales query with following parameters -
Total invoice value less credit notes
Number of invoices
Where customer name contains xxxx
I can get to the point of individual invoices but would just like a sum of total value within that period.
Many thanks in advance.