4 Replies Latest reply: Nov 20, 2012 6:58 PM by Jonathan Love RSS

    set analysis for for multiple conditions of the same field

    Jonathan Love

      I would like to write a set analysis that shows me where a range of values DOES occur in table_1, field_a and  DOES NOT have another range of in the same tabe and field.  For example, Account ABC has an installed product listing like:

       

      For example, I want to see every account here that has product 234 or 789, but does not have product 12345 or 345.

       

      Meyer - NO, has 234 but also has 12345 - ignore.

      Adams - YES, has 234 and does not have 12345 or 345

      Jones - NO, has 234 and 789 but also has 12345

      Smith - YES, 789 but does not have 12345 or 345

       

       

      AccountInstalled_Product

      Meyer

      12345
      Meyer6789
      Meyer234
      Adams234
      Adams6789
      Jones12345
      Jones6789
      Jones789
      Jones234
      Smith789
      Smith567