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 with Redwood for Oracle Cloud HCM   Begin Now

Using LIKE with FILTER() in an Analysis

edited Aug 18, 2020 3:28PM in Reporting and Analytics for HCM 3 comments

Content

I am trying to build a simple tile that gives the total number of employees with a job name that contains 'Director'. Example - 'Director of Compliance'

I run into errors trying to use the FILTER function in this case - FILTER("Worker Assignment"."Head Count" USING (DESCRIPTOR_IDOF("Workforce Management - Worker Assignment Real Time"."Job"."Job Name") LIKE('%Director%')))

Has any one encountered similar situation? Are there any workarounds?

Version

20B
Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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