7 Replies Latest reply: Aug 24, 2011 2:51 AM by livmon26 RSS

    How to use >= and <= in Set Analysis

      Hi All


      May I know how can make the below script with the help of Set Analysis. I tried but not sure how use >= and <= in Set Analysis. It is taking up only if I use = but it is not taking up when I use >= and <=.


      Can someone please do the required changes in the below script.


      Sum(if(DATE >= vCurMonthStartDate 
       AND DATE <= vCurMonthEndDate 
       AND TRANS_DATE >= vCurMonthStartDate 
       AND TRANS_DATE <= vCurMonthEndDate