3 Replies Latest reply on Aug 9, 2018 9:40 AM by Shinichiro Murakami

    List of ~200 Vendors. I want to exclude 5. How to do this without doing the CONTAINS function 205 times?

    Chase Barker

      Hope that the title is enough to go off but basically I have 210 vendors in total and there are 5 that I would like to exclude from the list of total overall consumption without writing a CONTAINS OR function 200+ times. What is the best way to go about doing this?


      I am trying to use it in a dashboard and use other tables as filters that DO have the 5 values that I would like to exclude. I am trying to avoid having the 5 values re-populate in this one table however though.


      Any feedback would be greatly appreciated!