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

  • Thread starter Thread starter andrear00
  • Start date Start date
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?
 
Try =Sum([credit])-sum([debit])

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