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
Number of employee with a salary = 0
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
0