Multi box - is it possible to sort using an expression

[#1]

Hi Guys,

I have an expression as one of the fields in a multibox - the issue is that this isn't visible in the sort tab (or font,number,presentation come to that) .

My query is as follows: is it possible to sort using an expression?.

The expression is a month number that i've converted to month name using the following

=

month('01/' & monthorder & '/00')

I'm in version 8.5

Many thanks

[amars · Accepted solution]

Hi Greeny,

You couldn't , you will need to create another dimension in ur script with the formula & will need to use it.

Like join (Tablename) Load month('01/' & monthorder & '/00') as monthName, monthorder Resident TableName;

& then use MonthName or whatever name u use in multibox.

Regards

Amar

[#3]

thought as much - thats what i did - just seems a bit of a backward way of doing it!

Thanks for the reponse