Expense - Revenue comparison in Page Footer

[2Kids]

How can I use the category sums of expense and revenue to help get a grand total sum, but instead subtract the Expense. The text box for each category is = Sum[(FieldName)], then in the page footer is the grand total with the same equation listed.

 

[JonoB]

You need to check out the actual names of the text boxes (under the 'other' tab in properties), and base your calculation on these names. Could be something like [Text21] - [Text20], or if you have named your fields correctly [Income] - [Expenses].

Hope this helps.