=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])
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do I calculate a total from a continuous form? 1
Enter Parameter Value - Custom Calculation In Report 2
Excel Excel Formula to covert a credit amount to a debit amount 1
Calculating two fields on based of the value of one field 3
Simple Question on Addition 3
Make controls not visible if is not null field 4
summing a text box 1
Cumulative Total in a Query 1

Top