Crystal Reports Sorting

[jrc1]

I have a colum with values like "SAL","BRH", "TGL", "BRC", "AGL", etc....(many more)

I want to sort in a specific order so I created a formula field shown below where it gives a column a new value (a,b,c) that I will use to sort on. The problem is the "IN" clause is not working. It returns the following error: The ) is missing.

Any thoughts on a better way to do this or correct the formula below??????

If {prpost.postcode} = "SAL" Then "a"
ELSE
If {prpost.postcode} IN ("BRH", "TGL", "BRC", "AGL") Then "b"
ELSE "C"

 

[kskid]

Change the parenthesis to brackets

If {prpost.postcode} = "SAL" Then "a"
ELSE
If {prpost.postcode} IN ["BRH", "TGL", "BRC", "AGL"] Then "b"
ELSE "C"