Get Started: AI Resources for Oracle Cloud HCM – Go Here
Progress with Redwood: Redwood Resources for Oracle Cloud HCM - Go Here
Progress with Redwood: Redwood Resources for Oracle Cloud HCM - Go Here
CASE statement THEN value
Content
I would like to add a case statement logic where if a condition holds true, a column value is displayed. But in addition to the value being displayed from the system, I would also like to add some descriptive text to the cell.
Exmaple-
CASE
WHEN "All Profile Content"."Rating Level 2" IS NULL
THEN 'Potential Rating:' + "All Profile Content"."Rating Level 1"
END
In the case above, If rating Level 2 is null, I would like to display the static text 'Potential Rating' before "Rating Level 1" from the system.
Is it feasible? Thank you!
Tagged:
0