How do I sort a list of values created in a calculation field.

Using the List function, the calc field produces:

2XL

3XL

4XL

L

M

S

XL

XS

How do I sort the result to read?

XS

S

M

L

...

There may be some custom functions that do this. Try Brian Dunnings web site.

See if this helps:

http://www.fmforums.com/forum/showtopic.php?tid/191271/

How do I sort a list of values created in a calculation field.

Using the List function, the calc field produces:

2XL

3XL

4XL

L

M

S

XL

XS

How do I sort the result to read?

XS

S

M

L

...

FilterValues(masterList; thisList)

Where masterList holds all items in the desired order and thisList is the items to be evaluated.

Example:

filterValues( "XS¶S¶M¶L¶XL¶2XL¶3XL¶4XL"; "M¶L¶XS")

Result:

XS

M

L

Thanks for the help.