=Sum([Credit(+)]-[Debit(-)])

A

andrear00

I want to minus two sum fields for their difference. What formula do I
use? =Sum([Credit(+)]-[Debit(-)]) I've got this formula in the Page
Footer. All I want is the difference of all of my credits minus my
debits. Can you please help me?
 
A

Allan Murphy

Try =Sum([credit])-sum([debit])

if debit is stored as a negative value ie -2.00 then use
=Sum([credit])+sum([debit])
 
Top