I want to sort a list using a custom order based on a value list. The field in question is a calculation field.

For some reason i cant get the field to sort in either the custom order or in alphabetical order.

Has it got something to do with the fact that the field is a calculation field?

Please help. Very stuck. Not sure where to from here.

I want to sort a list using a custom order based on a value list. The field in question is a calculation field.

For some reason i cant get the field to sort in either the custom order or in alphabetical order.

Has it got something to do with the fact that the field is a calculation field?

Please help. Very stuck. Not sure where to from here.

Try this;

it is buggy on some sort such as negative numbers, but it s a start

http://fmforums.com/forum/topic/26980-easysort-implementation/

Has it got something to do with the fact that the field is a calculation field?

Not likely.

Please help. Very stuck. Not sure where to from here.

A sample file showing the problem would be a good start.

Try this;

Can't say I see the connection myself.

Please excuse my ignorance, but can you tell me the best way to upload a sample file?

cheers

Zip the sample file, then upload the zip.

... upload a sample file?

see if this helps

Step 1

Find the file on your hard drive, and zip it.

Step 2

Do not use the Quick Reply, BUT instead, choose the More Reply Option

Step 3

Click on Attached Files and this will take you to your hard drive to locate your file that you want to attach and that you previously zipped. Select the file, and then click Attach This File, and then click Add Reply.

If you should have a problem write me a private message.

Lee

Hi Lee

I'm having trouble sending you a private message (see screen grab attached).

i have worked out how to load up my file but am hesitant to load up my database for public viewing. can i send it to you directly? there is obviously confidential data in the file i dont wish to publish. cheers emncwundy

Lee Smith - Message Error.tiff

I'm having trouble sending you a private message (see screen grab attached).

Oh no, I'll have to notify Stephen about this right now, thanks for the heads up.

i have worked out how to load up my file but am hesitant to load up my database for public viewing. can i send it to you directly? there is obviously confidential data in the file i dont wish to publish. cheers emncwundy

There are 2 ways to handle this. You can try to make a mockup of your file using fictitious data, or you can save a clone of your real file no records, and add a couple of bogus records so that we can see what's going on.

HTH

Lee

Is it possible the field is the wrong type? I.e., you've defined the calculation to return a text string, but the "calculation result" option is set to "Number."

Yes thanks Fitch that was indeed the problem!!

Now the lists are sorting perfectly. Thanks to all for your help.