My bad , 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 ?
Sum, Count on varchar in Aggregator
Moderators: chulett, rschirm, roy
-
- Premium Member
- Posts: 353
- Joined: Mon Jan 17, 2011 5:03 am
- Location: Mumbai, India
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.