Can we use Filter function with relational operator?
SummaryCan we use Filter function with relational operator?
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