If / Case function only returns value if true. No returns if false.

Hi,

I have a table with Column A (value including 'Yes' or empty). I added another column B, with expressions as below:

1.  If([Column A] = 'Yes', 'Valuable Item', 'Non-Valuable Item')

2. Case [Column A] when 'Yes' then 'Valuable Item' esle 'Non-Valuable Item' end

3. Case when [Column A] = 'Yes' then 'Valuable Item' esle 'Non-Valuable Item' end

I tried all above three expressions, but the results are same: Column B returns 'Valuable Item' if Column A is 'Yes', but nothing when Column A is empty. Please help me with this. Thanks!

Heath

(1) Answer

Login