2 Replies Latest reply: Nov 15, 2016 6:05 PM by Marco Wedel RSS

    Using Combined Or (+) in Set Analysis

    Jason Liau

      Hello,

       

      Having trouble figuring out how to do the following:

      Count of distinct [ID] where:

      A is greater than 0 and select all X

      or

      B is greater than 0 and select all X

      or

      C is greater than 0

      or

      D is greater than 0

       

      Here is what i have so far:

      count({<[A]={'>0'},[X]={'*'}> + <[B]={'>0'},[X]={'*'}> + <[C]={'>0'}> + <[D]={'>0'}>} DISTINCT [ID])


      the result is actually ignoring the field [X] and when I make the manual selection, I get the accurate count.


      Thanks in advance!