If / Case function only returns value if true. No returns if false.
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!