How to calculation positive and negative subtotals?

R

Rujie

I need to sum all positive amounts and sum all negative
amounts. They should be also printed on each page of a
report header section. Can any one give me some ideas how
I should do this?
Thanks.
 
D

Duane Hookom

The expression for all positive values would be:
=Abs(Sum([Amount]>=0 * [Amount]))
Negative values
=Sum([Amount]<0 * [Amount])
I'm not sure what you mean by "each page of a report header section."
 

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

Top