Page 2 of 2

Posted: Wed Feb 06, 2013 12:47 am
by chandra.shekhar@tcs.com
My bad :oops: , I read incorrectly.
I thought the grouping key is DUMMY column.
But now I have checked its the AgeGroup column itself.
But I don't understand that why the need for extra column, for counting purpose I can use AgeGroup column too, can't I ?

Posted: Wed Feb 06, 2013 8:19 pm
by ray.wurlod
You can, but there's no simple COUNT when calculating. You can count missing values, you can count non-missing values, but there's no actual count. If you know there are no missing values then a count of non-missing values would probably suffice.