3 Replies Latest reply: Oct 26, 2012 7:25 AM by smita1987 RSS

    How to get the previous month data at the expression level

      Hi ,

       

      I am  facing the  issue in getting the data for the previous month and i have written the expression as to get the previous month closing inventory qty as current month opening inventory qty but the thing is i am not getting this instead i am getting 0 value

      The expression which i have used is as shown below:

       

      For Current Month :

       

      sum({<CalendarMonthID={$(VCurrentCalendarFiscalMonth)}>}inventoryqty)

       

      For Previous Month:

       

      sum({<CalendarMonthID={$(Vcurrentcalendarfiscalmonth-1)}>}inventoryqty)

       

      But still i am not able to get the exact value

       

      Please help me on this as this is urgent.

       

      Regards,

      Smita