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

Receiving error message when filtering by prompt

Received Response
6
Views
3
Comments
edited Jan 14, 2021 2:44PM in Reporting and Analytics Taleo Enterprise 3 comments

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
 
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.
Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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