Sorting on a TRIM field

[frieb]

I'm trying to sort a TRIM (field) in Ascending order (which is also a group). Here is the order I want it to sort in:

2
4
7
9
12
22

This field is currently sorting as:

12
2
22
4
7
9

Thanks!

 

[lbass]

Create a formula:

tonumber({table.numericstring})

Insert the group on this formula instead of on the field itself.

-LB