5 Replies Latest reply: Feb 1, 2018 11:22 AM by Susan McMillan 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.