2 Replies Latest reply: Apr 2, 2012 8:15 AM by Clever Anjos RSS

    Set analysis replacing IF (with AND OR (AND .. OR ..)  etc)

    Robert Svebeck

      Hello all


      I'm building a dashboard and need to convert some tricky IF conditions into SET Analysis.

      List all green items (see attached picture for example):


      IF  (F2=A AND (F1=N OR F1=M)) OR
      (F2=B) OR
      (F2=C) OR
      (F2=D AND F1=P)

      then ...


      I've attached a picture where my example data is visualized in a simple way (green and white items).


      Regards, Robert