I need to use a multiple if statement, but I can't seem to get it to work.
I have a column of data that has either a '2', a '6', a '41' or is empty. If i enter the following in a calculated dimension, in a straight table, I get all the 2's and everything else says 'None'.
IF(Lock_Category <> '2', 'None', Lock_Category)
So how can I amend this to say, if the Lock Category is not equal to 2,6 or 41, to show 'None' , but still show the 2's, 6's and 41's.
Think that you should recheck your input-data, my guess is that you do not have a "41" there, but " 41" or the like. TRIM-function might be of help then. Function provided by Bismart works. Have added an example to illustrate
