Grouping

[#1]

Hi guys/gals,

Please refresh my memory. I need to display the number of employees per age group:

Example:

20 <= x < 30

But I can;t remember which function to use 🙂

Regards,

Werner

[#2 · Accepted solution]

Hi Werner,

look for "CLASS()"!!!

Good luck!

Rainer

[#3]

Super!!!

Thx.

[#4]

Hi

When i read from reference manual couldn't understand the concept. could you please tell me how it works?

class( expression, interval [ , label [ , offset ]] )

Creates a classification of expressions. The bin width is determined by the number set as interval. The result is shown as a<=x<b, where a and b are the upper and lower limits of the bin. The x can be replaced by an arbitrary string stated in label. 0 is normally the default starting point of the classification. This can be changed by adding an offset.

Examples:

class( var,10 ) with var = 23 returns '20<=x<30'

class( var,5,'value' ) with var = 23 returns '20<= value <25'

class( var,10,'x',5 ) with var = 23 returns '15<=x<25'

-Raghu.

[#5]

Hi,

see the attached example.

Good luck!

Rainer