7 Replies Latest reply: Feb 10, 2014 7:46 AM by Thomas Mumaw RSS

    Using Not Equal condition in Set Analysis

    Thomas Mumaw

      Happy New Year everyone.  I'm have a small issue when using not equal condition in set analysis.  Here is the statement I am using and it's returning everything greater than 14 and I only want everything that is not equal to a 14.  Thanks.




      Sum({<FISYR=,FISPD=,WKNO=,WEDAT=,[Cancel Reason] = {"<>14"}>}[Subtotal1A] * -1)