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

       

      Thanks,

      Kevin