running sum that subtracts instead of adds

  • Thread starter Thread starter J LITTLE
  • Start date Start date
J

J LITTLE

I have an amounts field which I would like to keep a running total only I
want it to subtract instead of add
 
If this is in a report then put a text box into the section where you want
the answer to appear. In it type
=-[YourNumberField]
In Properties on the Data tab set Running Sum to OverAll
Evi
 

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

Excel Formula or equation 3
Column sum incorrect upon subtracting 6
sum hours 1
HOW DO U ADD AND SUBTRACT AND KEEP A RUNNING TOTAL 2
How can I subtract values of one field from another field 1
Add/Subtract columns from tab to tab in same file 3
Calculations 4
Excel Subtracting multiple columns from another column 3

Back
Top