Forum Discussion
Multiple expressions translated into the same value
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?
1 Reply
- Greg_Deckler
Community Champion
ProcessENG You need SWITCH( TRUE(), ... ) Just add TRUE() as your first parameter and then you should be good.
