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

Number of employee with a salary = 0

edited Oct 6, 2017 8:32AM in Reporting and Analytics for HCM 9 comments

Content

Hello,

I try to do a really simple OTBI : get the number of employee with a salary = 0

I don't manage to do this, I have 0 result with the code below

is there someone who can help me?

thanks a lot

SET VARIABLE PREFERRED_CURRENCY='Local Currency';SELECT
   0 s_0,
   COUNT("Compensation - Salary Details Real Time"."Worker"."Person ID") s_1
FROM "Compensation - Salary Details Real Time"
WHERE
("Salary"."Annualized Salary" = 0)
ORDER BY 1
FETCH FIRST 75001 ROWS ONLY

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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