You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register
Get Started: AI 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)

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!