Subtracting the sub total instead of adding in Grand Total

[didajosh]

I am grouping a report on the basis of "Org-Code".
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 :

(IIf ([Org-code] = '601', sum (amount)) -
IIf ([Org-code] = '602', sum (amount)) )

This does not work.

I hope I am making sense, if it does not please let me know.

Thanks and Regards,
Dipali

[NeoPa]

Try :

Sum(IIf([Org-Code]='601',[Amount],IIf([Org-Code]='602',-[Amount],0)))

[didajosh]

NeoPa....
this works...this works...this works...!!!!!
i was loosing my mind...thank you soo much....i really appreciate it...

[NeoPa]

Not a problem. That's why we're here really - to help people do what we have some experience in :)