To remove NULL row occurring due to CASE statement — Cloud Customer Connect
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: Oracle Cloud SCM and Purchasing

To remove NULL row occurring due to CASE statement

in Reporting and Analytics for HCM 13 comments

Through OTBI report, trying to pull element entries having input value as STI Target %, Percentage only. So, put the following formula in the case statement:

CASE WHEN "Payroll - Element Entries Real Time"."Input Value"."Input Value Name" IN ('STI Target %', 'Percentage') THEN "Payroll - Element Entries Real Time"."Element"."Element Name" END

Issue: When applying this formula, the row with correct STI% percentage value coming, but along with that extra row coming containing NULL value:

So wanted to remove this NULL row.

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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