Creating user defined Age bucket in List box

[gizzel123]

Hi i have a column "Age".

I need to create an age bucket  which should have an interval of 5 yrs..

like-   (0-5),

(5-10),

(10-15)..... and so on.

Can u guys plz help..

thanks in advance

[#2]

try this

class(age,15,x,5)

[#3]

Use class function

Class(Age,5) as Age

[#4]

Hi,

Like this u can create a Bucket.

If( age>0 and age<=5,'0-5',

       If( age>5 and age<=10,'5-10',

              If( age>10 and age<=15,'10-15',

                       If( age>15 and age<=20,'15-20','20 Above') as Age_Flag

[#5 · Accepted solution]

sorry

try this

class(age,x,5)

[gizzel123]

I  used Class(Age,5) but then m getting 0,5,10,15.......

For "0"selection -ages are0-4,

"5"selection -ages are5-10,.....so on

How would i Define the displaying string too

?

cz when i use class(age,15,x,5) it display -x as bad field name..

[gizzel123]

I tried in chart...its working fine ..but not in list box.

[#8]

can u tell me what u have written in chart  and we let u know why it is not working in listbox

[gizzel123]

its working..i tried creating another list box...

Thanks All 

[#10]

Hi

thanks for marking as correct answer ,

pls let me know which expression is suits for u