20 Replies Latest reply: Sep 11, 2017 5:33 PM by Ruben Marin RSS

    How to create a Not Equal to Zero condition in Set Analysis?

    John Henry

      I know how to do set analysis with text, but with numerical values, I'm not sure.   I have a condition where I need to exclude all $0 values from my calculation.  Here is my syntax so far:

       

      [Gross Sales Order US Dollar Amount]-=0

       

      How do I select where values are not equal to zero?