I have a scenario where i have a union that pulls revenue and expense. Each half of the union has a subtotal than i have a grand total for the union as a whole. How do i calculate the difference between the sub total of the two parts of the union?
Example
Here i want to find the difference between the difference of revenue (union1) and expense (union 2) which would be $700.
Thanks in advance!!
| | Category | 2013 Amount |
| Union 1 | Revenue | $1,000 |
| | Subtotal | $1,000 |
| Union 2 | Direct Expense | $100 |
| | Indirect Expense | $200 |
| | Subtotal | $300 |
| | Grand Total | $1,300 |