Get Started with Redwood for Oracle Cloud HCM Begin Now
To ensure that questions get required attention from community members and are NOT left unanswered, it’s important for the author to indicate (by selecting “Yes” or “No” when prompted) whether the question was answered.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
CASE statement with IF
Summary
Need help with a CASE statement where it displays element input value if they have the element, else shows nullContent
Hello,
We have element set up like below table. Employees can have several elements. Some have Emp Stock plan (ex.Emp ID 938900) and some do not (Ex. Emp ID 976146)
Emp ID | Element Name | Display Input Value |
938900 | US Emp Stock Plan | 13 |
US Emp Holiday | FH | |
US Hourly Rate | 43 | |
976146 | US Emp Holiday | NA |
US Hourly Rate | 27 |
The desired result is that we need to show the Input Value ONLY if there is a US Emp Stock Plan element. Else show null. Like below -
0