Multiple expressions translated into the same value

[ProcessENG]

I want to be able to create a column that would look at the column [Scrap Reason] and assign a value based on the expression(s) in the [Scrap Reason] column.

I've tried the SWITCH function

but I get the error

I don't think the VALUE or FORMAT functions are going to help me with this, is there some other way to achieve what I am looking for?

[Greg_Deckler]

@ProcessENG You need SWITCH( TRUE(), ... ) Just add TRUE() as your first parameter and then you should be good.