Skip to Content
0
Former Member
Feb 27, 2007 at 01:21 PM

Exception aggregation in query - a chanlenge one

15 Views

Hi there,

I would like to count number of customers that their sold quantity is > 0.

I don't want to count customers that their sold qty is <=0 - Using exception aggr. that count all values<>0 is not good enough because it also count those with sold qty<0.

Any ideas?

Thanks, Nili