0 Replies Latest reply: Jun 5, 2013 10:39 AM by Ben Brunette RSS

    Multiple Set Intersections & Unions

      Hello Community,

       

      I am in need of set analysis advice.

       

      I am using multiple set selections to find their intersections and add them together (ie. {<...>*<...>+<...>*<...>}). This worked just fine for me up until now. I've isolated the issue to a "prior date" selection that I'm adding to my set. It's purpose is to enable me to compare two timeframes. When I leave the prior date selection out, the set analysis returns what I want it to but when added in, it zeros out the results.

       

      Here is an example of the code that I'm working with:

       

      1. This works!

       

      sum({1

      <[Client]=P()>*<[Client]={"NV*","*W"}>

      +

      <[Client]=P()>*<[Client]={"STR*"}-{"*W"},[Flag]={1}>

      } [Count Net])

       

      2. This doesn't.

       

      sum({1

      <[Client]=P(),[Submit Dt]={">=$(vPastStartDt)<=$(vPastEndDt)"}>*<[Client]={"NV*","*W"}>

      +

      <[Client]=P(),[Submit Dt]={">=$(vPastStartDt)<=$(vPastEndDt)"}>*<[Client]={"STR*"}-{"*W"},[Flag]={1}>

      } [Count Net])

       

      I've been struggling with this issue for a few weeks now and am really open to any suggestions.

       

      Thank you in advance for your help and insight!