Sum only negative values

[Marc S]

I have a report that shows various balances; some positive, some negative,
some zero. How would I, in the report footer, sum only the negative values?

Thanks,

Marc

 

[Duane Hookom]

Try:
=Sum(Abs([Balance]<0) * [Balance])