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. (newly added) Please note that it is also important to respond to EACH comment your question receives. Your Yes or No response ensures an accurate status for your question.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
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