4 Replies Latest reply: Nov 15, 2017 11:20 AM by Sunny Talwar RSS

    How do you calculate the sum of sales for rolling 12 months and rolling months 13-24

    Susan McMillan

      Hi, Can someone help me with this syntax? Or suggest a better formula?

       

      I need a rolling 12 months' sum of sales. This is my formula using today's date 11/14/2016 - 11/14/2017.

      sum{<Date={"$(='>=' & date(today()-365) )"}>} Sales)


      I also need the sum of sales for rolling months 13-24. This is my formula for 11/14/2015 - 11/14/2016

      sum{<Date={"$(='>=' & date(today()-730) )"}>} Sales) - (sum{<Date={"$(='>=' & date(today()-365) )"}>} Sales)


      Nothing seems to be working. I need it to work off today's date.

      Any help is greatly appreciated.