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.
Receiving error message when filtering by prompt
Content
Hello All,
I have a SQL formula that has condensed our Organization Level 2 data to make it more intelligible for the end user. Here is the formula:
CASE IFNULL("Requisition Organization"."Organization Level2 Name",'NONE')
WHEN 'ENGINEERED STRUCTURES' THEN 'STRUCTURE SYSTEMS'
WHEN 'ENGINE SYSTEMS' THEN 'ENGINE SYSTEMS'
WHEN 'FASTENING SYSTEMS' THEN 'FASTENING SYSTEMS'
WHEN 'STRUCTURE SYSTEMS' THEN 'STRUCTURE SYSTEMS'
WHEN 'WHEEL SYSTEMS' THEN 'WHEEL SYSTEMS'
ELSE 'RESOURCE UNITS' END
WHEN 'ENGINEERED STRUCTURES' THEN 'STRUCTURE SYSTEMS'
WHEN 'ENGINE SYSTEMS' THEN 'ENGINE SYSTEMS'
WHEN 'FASTENING SYSTEMS' THEN 'FASTENING SYSTEMS'
WHEN 'STRUCTURE SYSTEMS' THEN 'STRUCTURE SYSTEMS'
WHEN 'WHEEL SYSTEMS' THEN 'WHEEL SYSTEMS'
ELSE 'RESOURCE UNITS' END
As you can see, I've lumped all remaining values as RESOURCE UNITS using the ELSE statement. When I run the analysis, everything appears on my table correctly as indicated on the formula.
0