This content has been marked as final. Show 6 replies
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????