Virtual Column Sort Not Working

[Simon1]

I have a view sorted by a virtual column which is a reference from another table.

It  needs to be a virtual referenced column as the location may change on our system where that data comes from.

The view doesn't order properly

(Column says Location, but it is Location Virtual)

All the other columns are sorting correctly, but when I resort by Location they go back into this order.

[WillowMobileSys · Accepted solution]

What is the data type of the column?  The image shows it as Decimal which makes no sense based on how you are describing it.

[Simon1]

You're right, that makes no sense and was the reason sorting didn't work. 🙂

thanks for your eagle eyes.