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

    not equal <> in set analysis



      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