Only to include THEN VALUE not the ELSE value of CASE STATEMENT who have both input values

SWAGATA1991

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.

OHR131 – HR ALL Roster.catalog

Roster XML.txt

chieve that?

Raghavendra Raghunath-Oracle

Hi @User_0RJUC You must post this question in the OTBI forum , link below

https://community.oracle.com/customerconnect/categories/hcm-reporting-and-analytics-for-hcm

Raghu