Forum Discussion
Solved
Replace blanks.nulls in column with another value
Hi I have a below scenario where the New Calculated column need to be derived from Category column .For Category(N/A,Null or blank) value should be Adj's and others would remain same.Can Someone plea...
Does this work?
IF ( Types[Category] IN { "N/A", "", BLANK() }, "Adj's", Types[Category] )
AlexisOlson
Super User
Super UserDoes this work?
IF ( Types[Category] IN { "N/A", "", BLANK() }, "Adj's", Types[Category] )It worked.Thank you..
