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

Percentage of Employee With and Without Goals not showing properly in columns

in Reporting and Analytics for HCM 1 comment

Summary:

Hello again, I need help to check my case statements. The % of employees with and without goals are not reflecting properly.

CASE WHEN "Workforce Goals - Goal Status Overview Real Time"."- Goal Management Process"."Count of All Performance Goals" IS NULL THEN 'Without Goals' WHEN "Workforce Goals - Goal Status Overview Real Time"."- Goal Management Process"."Count of All Performance Goals" = 0 THEN 'Without Goals' ELSE 'With Goals' END

SUM(CASE WHEN "Workforce Goals - Goal Status Overview Real Time"."- Goal Management Process"."Count of All Performance Goals" IS NOT NULL AND "Workforce Goals - Goal Status Overview Real Time"."- Goal Management Process"."Count of All Performance Goals" <> 0 THEN 1 ELSE 0 END)

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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