You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register
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

edited Sep 10, 2020 12:57AM in Reporting and Analytics for HCM 6 comments

Summary

Need help with a CASE statement where it displays element input value if they have the element, else shows null

Content

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 - 

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!