Learn about the new Oracle AI Agent Studio for Fusion Applications: Watch Now
Progress with Redwood: Redwood Resources for Oracle Cloud HCM - Go Here
Progress with Redwood: Redwood Resources for Oracle Cloud HCM - Go Here
CASE when statements using null
Content
Ok, at least in my head this is hard to explain.
I want to look at two columns. And then in a third column return a label.
So, the two columns are Relo amount and Sign on bonus amount. I want to return a label based on if there is anything in each column. So if it's just relo, the label should be relo. If it is just sign on bonus then it should be Sign on bonus. If it's both, I want both and if it's none I want none.
I've been trying to use IF NOT NULL in my formula but it doesn't seem to like that. Is there another way to basically see if there is anything in a column and that means it's true?
Tagged:
1