?

[xyz1]

.

[tresesco]

Missing  Group By clause may be?

[Anil_Babu_Samineni]

Avg should need Group By. Without that it won't work for aggregate functions like Sum, Avg, Count ... in script

[jhoef-pv]

Hi Agrim,
Avg need group by

for example:

table:

load

field_1,

if(((Avg([Rating #])))='1', 'a', if(((Avg([Rating #])))=2, 'b')) as classification

from table.xls

group by  field_1;