Categories
- All Categories
- 5 Oracle Analytics Sharing Center
- 12 Oracle Analytics Lounge
- 193 Oracle Analytics News
- 41 Oracle Analytics Videos
- 15.4K Oracle Analytics Forums
- 5.9K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 66 Oracle Analytics Trainings
- 14 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
Only to include THEN VALUE not the ELSE value of CASE STATEMENT who have both input values

We are trying to pull out a input value by using the following case statement:
CASE WHEN "Payroll - Element Entries Real Time"."Element"."Element Name" IN ('Incentive Plan') THEN CASE WHEN "Payroll - Element Entries Real Time"."Input Value"."Input Value Name" IN ('STI Target%','STI Target %') THEN "Payroll - Element Entries Real Time"."Element Entry Value"."Displayed Input Value" END END
So, when an employee is having input value as STI Target%/STI Target % as well as other input values, then in the report those employees having one row with STI Target%/STI Target % and the other with NULL Value.
But in that column we want only the value when the employee having STI Target%/STI Target %. Is there any way to achieve this? Attached both xaml and catalog. Please suggest.
chieve that?
Answers
-
Hi @User_0RJUC You must post this question in the OTBI forum , link below
Raghu
0