Sorting of Buckets in a Listbox

[#1]

Hi all ,

I created 'Volume; Buckets in a listbox using 'Class' function. It works fine .

The expression I used is : Replace(Class(VOLUME,10),'<= x <','to')

Here I got a problem at sorting . I was unable to sort it in Ascending order. Trust me I used all sorting options available in properties.

Any help would be appreciated.

Thanks in advance.

Best Regards,

Susvith

[jonathandienst · Accepted solution]

Hi

I suggest that you use this expression in your list:

=Dual(Replace(Class(VOLUME,10),'<= x <','to'), Num(Class(VOLUME,10)))

Now you should be able to sort the list box using a numeric sort.

HTH

Jonathan

[#3]

Thanks so much . Its working.

[msteedle]

You can probably skip the "Num" in the solution. The Class function returns a Dual value with an associated numeric value equal to the lower bound of each bucket.