8 Replies Latest reply: Dec 24, 2015 10:18 AM by Neena Bhattarai RSS

    How to show Previous Month and Last Year Previous Month in a straight table?

    Neena Bhattarai

      I need to display the sales for Previous Month and Last Year Previous Month. Nothing seems to work for me. I also have some conditions that the sales needs to be summed up by.

      My expression for Last Year Previous Month

      SUM(MonthStart(Today()-13) AND IF(MATCH([Object Account],'5311','5312','5314','5315','5317') ,Sales))

       

      My expression for Current Year Previous Month

      SUM(MonthStart(Today()-1) AND IF(MATCH([Object Account],'5311','5312','5314','5315','5317') ,Sales))