Avatar of mariita
Flag for Canada

asked on 

Aggregation measure with equivalent of SQL "not in" operator

I am using the Oracle BI Administration Tool (BMM model) . How would I create an aggregation measure that uses the equivalent of the a SQL "not in" logical operator?
I need to count all records where the value does not equal '999999999','999999998','000000000'.  

The SQL equivalent would be something like:
sum(case when student_oen NOT IN ('999999999','999999998','000000000') then 1 else 0 end) as count_oen_other
Oracle DatabaseDB Reporting Tools

Avatar of undefined
Last Comment

8/22/2022 - Mon