11 Replies Latest reply on Apr 25, 2018 5:17 AM by Zhouyi Zhang

    Rolling Saving Calculation using week numbers

    Tony Ball

      Hi All,


      I'm hoping you can help me with a rolling calculation for a workbook I'm building.


      I have values in the data collected on a weekly basis


      Firstly I want to use the last week of 2017 as the baseline amount (week 53) - I then want to subtract the value from week 4 of 2018 off week 53 value.


      so for example week 53 value 1000  - week 4 value 800 = 200


      I then want to subtract week 4 value from week 8 value


      so for example week 4 value 800 - week 8 value 780 = 20


      I want keep rolling my calc in this way on a 4 weekly cycle BUT accumulating the amounts from each calculation. So using the example above the amount my calc would display is 220


      I hope this makes sense but please let me know if not.