Counting rows and summing columns in same aggregator stage

manuel.gomez · Post by **manuel.gomez** » Fri Oct 29, 2010 2:45 am

I am sure this must be something already discussed, but I just cant find any posts in the forum.

Is not possible to count rows and sum columns in the same Aggregator stage?

Due to Aggregation Type property, you always have to choose between 'Calculation' (where there is no calculation for counting, the most similar I found was Weighting column) and 'Count Rows'

Is not possible to do both, as you do in typical SQL queries?

select count(*), sum(col1), sum(col2) from table

Thanks a lot!

ArndW · Post by **ArndW** » Fri Oct 29, 2010 2:55 am

It would seem not, I just played around with the aggregator stage and couldn't find a way of doing with just one stage. Perhaps someone else has found another solution.

yimwai · Post by **yimwai** » Fri Oct 29, 2010 2:56 am

add a column before with value "1" , then sum

ArndW · Post by **ArndW** » Fri Oct 29, 2010 3:02 am

yimwai - that's a simple and elegant solution

manuel.gomez · Post by **manuel.gomez** » Fri Oct 29, 2010 4:51 am

ArndW wrote:yimwai - that's a simple and elegant solution

I agree, I guess I will do this!