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