2 Replies Latest reply: May 28, 2013 1:35 AM by Selvakumar S RSS

    Set Analysis Date range

      Hi All,


      I need to get the sum of sales for date range between x to y date. My Expression look like this


      =(sum({$<PROMOTION_CODE=,PROMOTION_NAME=,STYPE_KEY={2},SALES_DATE = {">=$(=date(max(SALES_DATE)-21))<=$(=date(max(SALES_DATE)-1))"}>}DAY_SLS_ACT_BC))



      I checked in header whether the date parameter is passing or not,


      =(sum({$<PROMOTION_CODE=,PROMOTION_NAME=,STYPE_KEY={2},SALES_DATE = {">=20/02/2013<=12/03/2013"}>}DAY_SLS_ACT_BC))



      But i'm get the sum as "0". Please help me to identify where i'm wrong in this expression


      Thanks in advance,