6 Replies Latest reply: Feb 14, 2011 5:25 PM by Peter Means RSS

    Set Aanalysis - Referencing the cuurent selection

      Within the current selection, I'm trying to count everybody who's spouse is also selected. Here's what I've got:

      = Count({$
      [Relation Related ID] = {$[Relation ID]}>
      }
      distinct [Relation ID])

      The part in bold {$[Gifts ID]} is what I know is wrong. I want that to represent all of the Relation ID's of the current selection. I know if i were to say [Relation Related ID] = [Relation ID] it would look for rows where the two fields were equal. What I want is rows where the value in [Relation Related ID] can be found anywhere in [Relation ID] of the current selection. Does that make sense?

      Thanks very much for any help you can offer.