Automatic sorting of age band

[chrislyonsuk]

I'm using an age band as below:

If(age > 0 and age < 20, ('Under 20'),

If(age >= 20 and age < 30, ('20-30'),

If(age >= 30 and age < 40, ('30-40'),

If(age >= 40 and age < 50, ('40-50'),

If(age>= 50 and age < 60, ('50-60'),

If(age >= 60 and age < 70, ('60-70'),

If(age >= 70, ('70 & Over') ))))))) as Age Band

but I wish to automatically sort them so 'Under 20' is first on any list/sheet/table produced and not last. I have tried to use dual() but I cannot get it to work. Any help would be appreciated.

Thanks 

[JuanGerardo · Accepted solution]

Use a dual field to order a string by a number, for example:

Dual('Under 20', 20)

Dual('40-50', 40)

Etc.

And I would recommend to have a look at the Class() function, maybe is useful for you.

JG

[chrislyonsuk]

Brilliant, Thank you