how to use aggregation function without group by

[#1]

Hi ,

I have a piece of code and its throwing invalid expression error when i execute it.I am not using group by on the basis of count function. Thats why its showing error.But i dont want to use group by here dats my requirement.

Please let me know how can i achieve the above requirement.

load

     '$(i)' as Month,

     fd_code as [Client source],

     if(pri_code=1 and  wc_code= '01' and wo_Diff <='1' ,count(wo_number)) as [No Of Work Orders 1]

   if(pri_code=1 and  wc_code = '01'  ,count(wo_number)) as [No Of Work Orders 1.1],

    if(pri_code=2 and  wc_code = '01' and wo_Diff <=2,count(wo_number)) as [No Of Work Orders 2]

from $(vQVDDataDir)\XYZ.qvd (qvd)

     where num(month(floor(wo_completionDate))) >= '$(i)'-1 and num(month(floor(wo_completionDate))) <= '$(i)' and year(floor(wo_completionDate))='2015'

     and isnull(proj_number) and pri_code='$(j)' and  wc_code = '$(j)' and wo_Diff <='$(j)'

     group By

     fd_code;

Thanks,

Vasudha Mishra

[Gysbert_Wassenaar]

If you don't want a group by then don't add any fields that aren't aggregated. You're using fd_code, pri_code, wc_code and wo_Diff without aggregating them, so these fields must be part of the group by clause. There is NO way to do it otherwise.