4 Replies Latest reply: Jun 23, 2013 9:11 AM by Selvakumar S RSS

    Previous Year Same month Set Analysis

      Hi All,



      I want to take the sum of previous year same month based on my month selection. For that i wrote like this below,






      ( {<Year=,
      Month =,
      SALES_DATE = {"$(=date(MonthName(AddMonths((max(SALES_DATE)), -12)),'YYYYMM')"}
      >} Sales Cost



      But its not working. What im doing wrong here..  My Sales date format is YYYYMM