3 Replies Latest reply: Dec 5, 2011 12:46 AM by Abhinava Chandra RSS

    not equal in set analysis

      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)