Thread: How to count negative numbers
View Single Post
  #3 (permalink)  
Old July 1st, 2009, 02:45 PM
mmcdonal mmcdonal is offline
Friend of Wrox
Points: 9,516, Level: 42
Points: 9,516, Level: 42 Points: 9,516, Level: 42 Points: 9,516, Level: 42
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Mar 2004
Location: Washington, DC, USA.
Posts: 3,060
Thanks: 0
Thanked 10 Times in 10 Posts
Default
Do you mean Sum the negative numbers? Or sum the negative numbers with the positive? Or sum the negative numbers AS positive numbers along with the positive, etc?

I am assuming this is on a report.

Put a text box on the group footer, or footer of the report, and then just type in =Sum([Deviation]) to get that sum.

If you want the negatives as positive, and the positive, you can do: =Sum(Abs([Deviation]))

You can also put the text box on the footer or header (group or report) and put code on the On Format event for that section to create your equation and put the result in the text box, etc.

Did any of that help?
__________________
mmcdonal

Look it up at: http://wrox.books24x7.com
Reply With Quote