10 Replies Latest reply: Jan 22, 2016 4:17 AM by Mary Pham RSS

    not equal <> in set analysis

      Hello,

       

      I'm looking for the good syntaxe in set analysis to have the not equal expression:

      For exemple I want have the amount of sales for all my articles but not my "Jean" in the past year.

       

      so I did : Sum({<Year={$(=Only(Year)-1)},Article-={'Jean'}>} AmountSales)

       

      But the symbol : -= is underline like if it's wrong.

       

      So what is the good syntaxe for exclude always an article ?

       

      (I don't want use the IF syntaxe)

       

      Thank you