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 
       AND CATEGORY='MARKETING',SALES))
      
      

       

      Thanks

       

      Attitude