Average wise bucket

[dhanu_today]

Hi Everyone ,

I have the fields like direction,ID,SAL.I have calculated the average by sum(sal)/Count(Total ID)

After getting above result i have to show the ID's count bucket wise based on the average calculated above.

DIRECTION	Average(i.e. sum(sal)/count(Total ID)	Count(ID)	SAL<=0	SAL>0 AND SAL<=10000	SAL>10000 AND SAL<=20000	SAL>20000 AND SAL<=50000	SAL>=50000 AND SAL<=100000	SAL>=100000
S	8993.17	7	1	5		1
N	18901.05	6	1	2	1	1	1
E	1381419	7	1	3	1	2
W	10128503.04	4				1	1	2

Here am attaching the sample data as well.

Thanks in adv,

Dhanu

[MK_QSL]

But as per my knowledge

0.05

0.08

both are >= 0 not <= 0

Can you please check again and upload a correct file?

[dhanu_today]

Hi Revised data .

Thanks,

Dhanu

[MK_QSL]

Still looking wrong.. but use enclosed file..