Get Started with Redwood for Oracle Cloud HCM Begin Now
To remove NULL row occurring due to CASE statement
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:
0