I have a problem where I have to produce a report from a transaction file with a total of all negative values in one column and a total of all positive values in another. I have been hitting my head against a brick wall trying to find an SQL expression that will do it.

Can anyone help?