2 Replies Latest reply: Apr 2, 2013 1:24 AM by Some Nath Roy RSS

    prev month sum, last month , comparison last month data

      Hi guys,

      I need to calculate sum of views for the previous month based upon the current month selection. I use the expression below but it does not work.

       

      .

      =sum({<Month={'$(=(vprevMonth))'}>}Views). It gives the count as 0.

       

      The variable vprevMonth is set as left(MonthName(AddMonths(Date,-1)),3)

      Kindly help me with this. Urgent!

      Thanks a ton!