Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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)
You can write it as either:
STATUS-={SL}
or
~STATUS={SL}
Since the former didnt work for you please try the latter.
Kiran
IF SL is a fieldvalue, try STATUS<>{'SL'} or STATUS={'*'}-{'SL'}
Hi Dhanupriya,
Use the following,
STATUS=E({1<STATUS={"SL"}>})
BR,
Abhi