Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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
thought as much - thats what i did - just seems a bit of a backward way of doing it!
Thanks for the reponse