There are two "Org-Code"- "601" Income and "602" Expense.
It calculates sub totals accordingly.
In the grand total, it simply sums everything. Instead I want the difference.
I tried adding a Text box in the report footer field, and its control source as :
Expand|Select|Wrap|Line Numbers
- (IIf ([Org-code] = '601', sum (amount)) -
- IIf ([Org-code] = '602', sum (amount)) )
I hope I am making sense, if it does not please let me know.
Thanks and Regards,
Dipali