Using abs in reports

[Stryder09]

I am trying to run an absolute number in my report and it doesn't work. My
understanding is that Abs removes the negatives and adds all the numbers up
but I cannot get it to work for me. This number is a currency value and they
fall as negatives and positive dollars I need to know the absolute number
being written off.

I've tried =Abs([CostDifference]) and when I run the report it only gives me
the very last value in the report.

I've tried =Abs(Sum([CostDifference]) and when I run the report it gives me
the sum only.

Any help would be appreciated.

Brad

 

[Allen Browne]

Did you intend to sum the absolute values?

=Sum(Abs([CostDifference]))