conditions in aggregate function
Hi,
Iam doing a report of invoice list, and at the report summary I would like to place a total amount of all invoices. But a simple sum function will not do, because not all invoice should be added. Can I put some conditions to tell which invoices are to be included in the sum?
James
Iam doing a report of invoice list, and at the report summary I would like to place a total amount of all invoices. But a simple sum function will not do, because not all invoice should be added. Can I put some conditions to tell which invoices are to be included in the sum?
James