Categories
- All Categories
- Oracle Analytics and AI Learning Hub
- 34 Oracle Analytics and AI Sharing Center
- 22 Oracle Analytics and AI Lounge
- 276 Oracle Analytics and AI News
- 47 Oracle Analytics and AI Videos
- 16.1K Oracle Analytics and AI Forums
- 6.3K Oracle Analytics and AI Idea Labs
- Oracle Analytics and AI User Groups
- 99 Oracle Analytics and AI Trainings
- 16 Oracle Analytics and AI Challenge
- Find Partners
- For Partners
Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture
Can we use Filter function with relational operator?
ForSly
Rank 5 - Community Champion
Summary
Can we use Filter function with relational operator?
Content
I am trying to filter all students applicants who have scored at least 96% and above all the application then divide the total with all distinct applicants using the Filter function as shown however I keep getting an error I am wondering if its because I cant use a relational operator with a filter function or I am missing something else. anyone with some suggestions on this?
(FILTER("Fact - Application"."# of Applications" USING ("Application Event Details"."Student" >=96)/"Fact - Application"."# of Distinct student Applicants) *100
0
Answers
-
What is the error you're getting?
0 -
It says there is a syntax error
0 -
found a work around on this. thanks for your help
0
