Age bucket sorting is not happening

[Anonymous]

Dimension =PurgeChar((class(Ageing,5,'-')),'<=')

Sort - =num(trim(subfield((PurgeChar((class(Ageing,3,'-')),'<=')))))

Final result should be 0-5, 6-10, 11-15,......

[sunny_talwar]

Try this as your dimension:

Dual(PurgeChar(Class(Ageing, 5, '-'), '<='), Class(Ageing,5,'-'))

[swuehl]

If you want to nearly match your expected ranges, you can try something like

=Dual(Floor(Ageing,5,1)&'-'&(Floor(Ageing,5,1)+4), Floor(Ageing,5,1))