2 Replies Latest reply: Feb 14, 2011 6:19 PM by Peter Means RSS

    Set Analysis - Basic question about intersection operator (*)

      I've read up on a few threads about this but haven't found the specific answer that I'm looking for. Basically, I'm trying this expression for a straight table:

      = count({<[Gifts Type Code] = {c}> * <[Gifts Honor Marker] = {B}>} [Gifts ID])

      and it yields 0. However if I use this

      = count({<[Gifts Type Code] = {c}, [Gifts Honor Marker] = {B}>} [Gifts ID])

      It works. My question is why? It seems like the two statements should yield identical results

      Obviously for this specific case I can use the second statement, but I use the intersection operator (*) in several other places so I want to make sure I know what it actually does.

      Thanks