27 Replies Latest reply: Mar 20, 2017 4:24 AM by Peter Cammaert RSS

    Set Analysis not equal to Syntax

    Cliff Clayman

      I am trying to use Set Analysis for a not equal to value.

       

      =Sum({$<[Flag]-={'x'}>}[Amount])

       

      This is not working properly.  When I change -= to just = , I get the correct amount for the ones that should be equal to x.  How should I write this to sum the Amount where the Flag is not equal to x?