Let's Reconnect, thank you for making 2022 our best year yet.

Look Back
Using filter with OR — 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

Using filter with OR

Received Response
15
Views
1
Comments
in Reporting and Analytics for HCM 1 comment

Summary:

We want to add a filter to a fact column to only return Direct Applications, so no Agency Referrals from Source or Internal Candidates from Job Application Basic Information

Content (required):

How do we add a FILTER that uses OR? Trying:

FILTER("Facts - Job Application Counts"."Number of Job Applications" USING ("Source Tracking - Source Information"."Source Name" NOT IN ('Agency Referral'))) OR USING ("Job Application - Basic Information"."Internal Candidate" <> "Y")

Version (include the version you are using, if applicable):

22D

Code Snippet (add any code snippets that support your topic, if applicable):

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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