custom sort order

[jrhessey]

Is there anyway I can make a formula that would allow me to sort data by a variable I select. I have a field in a report and I would like to sort it ascending starting with c instead of a. Is there a way I could accomplish this? Thanks for any help!

 

[lbass]

Please show a sample of your data sorted the way you would like.

-LB

 

[jrhessey]

OK

On the report I have categories such as,

6142
8142
ASSC
CAIR
NTFT

I would like to have it start with C and go down instead of the natural ascending sort

CAIR
NTFT
6142
8142
ASSC

 

[lbass]

Create the following formula:

if isnumeric(left({table.field},1)) then "2"+{table.field} else
if left({table.field},1) in ["A","B"] then "3"+{table.field} else
"1"+{table.field}

Use this formula as the sort field, but display only {table.field}.

-LB