Percentage of Employee With and Without Goals not showing properly in columns — Cloud Customer Connect
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

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

in Reporting and Analytics for HCM 3 comments

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!