Sort on Item No Non Numeric 1

[codrutza]

CRXI

Hi

I have a formula @miditem:
mid({ReferenceNumber},9,1)+mid({ReferenceNumber},10,1)
and then I have a formula @miditemno:
tonumber({@miditem})

I Have to sort on @miditemno, (because for example if I sort on {@miditem} is 1, 11, 3, 4 and I need 1, 3, 4, 11) but when I put the formula @miditemno in Record Sort Expert gives me the error:
The string is non numeric

Is there any other way to sort the records, please?

 

[SkipVought]

Hi,

If miditem contains non-numeric characters, of course you will get an error.

Skip,

_{Just traded in my OLD subtlety...
for a NUance!}

 

[Charliy]

For miditerm try something like:

if isnumeric({@midterm})
then val({@midterm})
else 0