3 Replies Latest reply on Feb 14, 2020 8:28 AM by Jim Dehner

    formula for dynamic rolling 7 month sum/count

    kevin smith

      Hi All,


      I'm looking for a formula that will allow me to summarize records based on previous rolling 7 months.


      Example below: it should return 41 for Jan 2020 (sum of June to December 2019), 45 for Feb 2020 (Sum of July to Jan 2020)


      Also attached a .twbx