1 Reply Latest reply: Jul 13, 2017 11:09 AM by Sunny Talwar RSS

    Show previous month data by expression

    Gina Engledow

      Hi,

      I am trying to write an expression that will show the previous month's data of sales.

       

      I have been able to use this formula to show the previous years sales in another table

       

      Sum({<Year={'$(=Year(Today())-1)'}>}Sales)

       

      But when I replace Year with Month it does not bring back any values.

       

      Thanks for helping!