We have a string column( say 'Random') with 4 values in it say...Pen, Paper, Ink, Sketch.
When user drags 'Random' column in a list...he should see values in this order...( Sketch, Ink, Paper,Pen)..which is not related to ascending or descending sort.
So I wrote a case expression by assigning numbers ( 4 numbers --> 4 strings) to above strings and sorted it as expected and issue resolved.
But now the original problem is what if tomorrow if this column ( 'Random') get's update with additional values like Book, Envelope etc. !!!
User is expecting that all the other values after 4th value may fall randomly anywhere....he's fine with ordering first 4 values which is already in place.
Can anyone suggest.
In your case expression, do else 5
Thanks John.
That is indeed the solution :-)