SQL aggregate SUM statements 1

[dolodolo]

Hi,

I am trying to get rid of zero amounts on my report. I have the following code in my script:

Having SUM(
abs(sum(Case tr.upostdate When convert(datetime,'01/01/#dat1#') then d.samount else 0 End)) +
abs(sum(Case tr.upostdate When convert(datetime,'02/01/#dat1#') then d.samount else 0 End)))<> 0

When I run it I get this error:

Cannot perform an aggregate function on an expression containing an aggregate or a subquery

Any help would be much appreciated.

Thanks

 

[cmartin75]

I think you can get the same results without the first sum

Having abs(sum(Case tr.upostdate When convert(datetime,'01/01/#dat1#') then d.samount else 0 End)) +
abs(sum(Case tr.upostdate When convert(datetime,'02/01/#dat1#') then d.samount else 0 End))<> 0

 

[dolodolo]

Thanks so much - that works great!