S
Sue
I have many transactions on a report. I having a Category with 2 listed. One
is Expense and one is Revenue. I am trying to subtotals the Expense and then
the Revenue and then the total of both. I have a Category Footer with a text
box that has a sum of the totals. It works for Expense but the Revenue
subtotal is the Grand Total. Then I need to know where to put the Grand.
Like below:
Category Current Needed
Subtoal Expense: 100 100
Subtotal Revenue 500 400
Grand Total: Nothing 500
is Expense and one is Revenue. I am trying to subtotals the Expense and then
the Revenue and then the total of both. I have a Category Footer with a text
box that has a sum of the totals. It works for Expense but the Revenue
subtotal is the Grand Total. Then I need to know where to put the Grand.
Like below:
Category Current Needed
Subtoal Expense: 100 100
Subtotal Revenue 500 400
Grand Total: Nothing 500