If Then selective summarizing

[gkrenton]

Have a table that has gross qty & gross returns report as either positive or negative numbers. Trying to capture the gross returns as 1 number & the gross qty as another. However
if I use the if slsqty < 0 then sum(slsqty) it gives me the net number - how can I limit this statement to only adding the negative quantity - then the reverse would allow me to get gross sold.

 

[lbass]

Create a formula {@negqty}:

If {slsqty} < 0 then {slsqty} else 0

Create a similar formula {@posqty}:

If {slsqty} > 0 then {Slsqty} else 0

Place these in the detail section and then insert summaries on them.

-LB