Get Started with Redwood for Oracle Cloud HCM Begin Now
Case statement is not working in OTBI report.
Summary:
CASE WHEN "Worker Assignment Details"."PER_ASG_DF_REHIRE_DATE_" IS NOT NULL THEN "Worker Assignment Details"."PER_ASG_DF_REHIRE_DATE_"
WHEN "Worker Assignment Details"."PER_ASG_DF_ACQUISITION_DATE_" IS NOT NULL THEN "Worker Assignment Details"."PER_ASG_DF_ACQUISITION_DATE_" WHEN "Worker Payroll"."Payroll Start Date" = to_datetime('03/15/2019', 'MM/DD/YYYY') THEN "Worker"."Enterprise Hire Date"WHEN "Worker Payroll"."Payroll Start Date" = to_datetime('07/28/2019', 'MM/DD/YYYY') THEN "Worker"."Enterprise Hire Date" WHEN "Worker Payroll"."Payroll Start Date" = to_datetime('09/29/2019', 'MM/DD/YYYY') THEN "Worker"."Enterprise Hire Date"ELSE "Worker Payroll"."Payroll Start Date" END
Tagged:
0