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
How to filter the column values by another column?
Summary:
I'm currently creating an OTBI report under this Subject Area: Workforce Management - Checklist Real Time
I want to filter employees which have these Response Answers: Staff and Supplier
I used the Filter formula under Edit Column Formula tool:
However, the syntax is invalid:
Here's the error message:
Formula syntax is invalid.
[nQSError: 10058] A general error has occurred. (HY000)
[nQSError: 43113] Message returned from OBIS. (HY000)
[nQSError: 22032] Function FILTER requires at least one measure column in its first argument. (HY000)
SQL Issued: SELECT FILTER("Worker"."Person ID" USING ("Checklist Questionnaire"."Response Answer" IN ('Staff', 'Supplier'))) FROM "Workforce Management - Checklist Real Time"
0