How to "sum" a calculation in a report

[neelsfer]

Is it possible to sum a value from a calculation in a textbox in a report
I use the following formula and cannot use =Sum([totals]). I ignore negative values with this formules when subtracting
The Totals textbox code is:

=IIf([issued]-[on_hand]<0,0,[issued]-[on_hand])

please assist

[Rabbit]

You can also swap negative values to positive using the Abs() function.
Abs([issued]-[on_hand])

What is total? If you want to sum the formula, then why are you summing total and not the formula?
Sum(Abs([issued]-[on_hand]))

[Oralloy]

neelsfer,

Another alternative that you have to the inline-if (Iif) is the maximum value function (Max), as in

Max([issued]-[on-hand], 0)

So your summation then becomes

Sum(Max([issued]-[on-hand], 0))

Cheers,
Oralloy