6 Replies Latest reply: Apr 3, 2013 9:34 AM by Vijit Jindal RSS

    How can I achieve the common data for the last three months

      I need to get the count of Id's which are having status '2' for the last three months...

       

      Created three variables to get last three months dates as below

       

      vMaxmonth = Date(Max(Month_Date),'DD/MM/YYYY')

      vLastmonth = Date(MonthEnd(AddMonths('$(vMaxmonth)',0)),'DD/MM/YYYY')

      vLastmonth2 = Date(MonthEnd(AddMonths('$(vMaxmonth)',-1)),'DD/MM/YYYY')

       

      and used these variables in chart like this

       

      Count({$<Month_Date={'$(vMaxmonth)'}+{'$(vLastmonth)'}+{'$(vLastmonth2)'},Status={2}>}ID)

       

      but it is giving me all the records, not the common records having status 2 for last three months,

       

      Anybody please suggest...