Can it be possible to calculate sum of salary and number of

hi_manoj · Post by **hi_manoj** » Sat Mar 10, 2012 2:27 pm

Hi

I was trying to implement a senario where i have in comming data from a dataset. I am trying to do this with one aggregator stage

Empno Deptno Salary
1111 10 200
2222 20 300
3333 10 400
4444 30 400
5555 20 400
6666 10 400

oupt put

Deptno Sum_Salary Mem_count
10 1000 3
20 700 2
30 400 1

Regards
Manoj

chulett · Post by **chulett** » Sat Mar 10, 2012 3:33 pm

So... what exactly did you try? What happened when you tried it?

Mike · Post by **Mike** » Sat Mar 10, 2012 5:34 pm

And yes it can be done with a single aggregator stage with a little help from a column generator or transformer stage preceding it.

Mike

ray.wurlod · Post by **ray.wurlod** » Sat Mar 10, 2012 8:17 pm

It can be done with a single Aggregator stage, but you might have to use SUM(1) rather than COUNT.