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