Applying filters in mapping tables

Hi Community Members,

 

I have two tables: contact & account details (banking products) one to many mapping linked via customer id (sample data attached). I need to find all the contacts that don't have a particular account type say IRA SAVINGS in the given example. When I am applying filters (screenshot attached) - it gives me cust_id 2 as well since it has checking account as well although I want it to give me only cust_id 1. How can I apply this filter? Thanks

Like 0

Like

1 comments

Try changing

  1. "count > 0" to "count = 0" 
  2. then change "AccountType != IRA SAVINGS" to "AccountType = IRA SAVINGS"

Ryan

Show all comments