not equal <> in set analysis

[#1]

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

[#2]

Hi,

Try Sum({<Year={$(=Only(Year)-1)},Article={'*'}-{'Jean'}>} AmountSales)