I have a table that is grouped by Invoice Number. each invoice shows the product and the components that makeup the product.
I also have invoice totals, and grand total of all invoices
I wan to add total of component 1 and total of component 2
Not sure how to do this. any suggestions would be appreciated, thank you.
George809C
You can sum a field with an expression. This is where you add sum(compID) to a formula. The result depends how the data is grouped.
You can group (and sum) by rows and/or columns.
The grouping properties may need to be reviewed to get the desired result (view > properties).
Grouping can get messy especially when reports contain multiple records + page breaks. A workaround is to sum within your select statement. Then you add this summed field without grouping (or less intensive group nesting). Try sum over partition by adding this line to your select statement:
SUM (COMPID) OVER (INVOICEID) AS INVOICESUM
17 People are following this question.
