Get Started: AI Resources for Oracle Cloud HCM – Go Here
Progress with Redwood: Redwood Resources for Oracle Cloud HCM - Go Here
Progress with Redwood: Redwood Resources for Oracle Cloud HCM - Go Here
Employees With or Without Goals Report - Missing data
Summary:
Hello again, I need some help on my report. I need a report of Employees With or Without Goals. I created case statements for Total Employees, Goal Status (With or Without Goals) Employees with Goals, Employees Without Goals, % Employees with Goals and %Employees Without Goals
The report is not pulling the employees without goals. The employees without goals are missing. Can you help me check the statements? Thank you in advance.
COUNT(DISTINCT "Worker"."Person Number")
CASE WHEN COUNT ("Performance Goals"."Performance Goal Name") > 0 THEN 'With Goals' ELSE 'Without Goals' END
COUNT(DISTINCT CASE WHEN "Performance Goals"."Performance Goal Name" IS NOT NULL THEN "Worker"."Person Number" END)
Tagged:
0