6 Replies Latest reply: Dec 23, 2009 12:12 PM by susant Kumar swain RSS

    Regarding in set analysis coding

    susant Kumar swain

      Hi,

      I have a two Data field and one stock filed and one stockcode field. i.e DATE1,DATE2,STOCKQTY,STOCKCODE.

      Now i am writing one expression which is giving me correct answer.

      i.e COUNT(DISTINCT IF(DATE1=DATE2 AND STOCKQTY>0, STOCKCODE))

      now i want to write same thing in SET ANALYSIS . BUT I AM UNABLE TO WRITE THE CORRECT SYNTAX.

      CAN ANYONE HELP ME???????

      BECAUSE I WANT SIMULTANEOUSLY FOR LAST CONSECUTIVE MONTHS WHAT IS STOCKCODE COUNT????