not equal in set analysis

[#1]

how i can use not equal in this expression with status i have tried with '<>' and '-=' but its not working.

i don know where i am doing mistake, can you please help me out of it.

SUM({<SALES_YEAR={'$(VMaxYear)'},SALES_MONTH=,SALES_DAY=,DATE={'<=$(VMaxDate)'},SALESYEARMONTH=,STATUS  {SL}>}SALES_AMOUNT)

[#2]

You can write it as either:

STATUS-={SL}

or

~STATUS={SL}

Since the former didnt work for you please try the latter.

Kiran

[christophebrault]

IF SL is a fieldvalue, try STATUS<>{'SL'} or STATUS={'*'}-{'SL'}

[#4]

Hi Dhanupriya,

Use the following,

STATUS=E({1<STATUS={"SL"}>})

BR,

Abhi