Please review this previous question for further info:
That worked great. The problem now is some of my results are a little off. The AvgAmt, MaxAmt, and MinAmt are off. They should not include in the records in the average that the "Num" field is 0. Currently they do.
I tried adding this to the statement for the AvgAmt field but it is not right even though it executes fine:
Avg(Case WHEN Bids > 0 THEN Amt Else 0 End) as 'TestAmt'
I get $17.59 when it should be $138.37
PLEASE HELP!!! Thanks in advance.