Concatenate with a CASE WHEN STATEMENT - Oracle Business Intelligence - OBI

Question

Is it possible to create a CASE WHEN statement and concatenate results?

For example:

CASE WHEN "A" IS NULL THEN 'Orphan -'|| "A" ELSE "A" END

Donna Fazio · Answer

Thank you so much for your quick response.. Yep.. It is possible. I should have caught my error when i typed this example.

I meant to concatenate with "B" not "A".. Oh dear! End of the week blurs!!

Thanks again!

Gianni Ceresa · Answer

Yes, it is possible.

Did you try it? Did it work? If no, what error did you get?

What product and version? What is the exact formula you did try?

Just saying: your condition is A is null, but then you want to concatenate 'Orphan -' with null?