5 Replies Latest reply on Jan 25, 2019 3:04 PM by michael.adeyemo.1

    Rolling 12 Month Calc....Almost there

    michael.adeyemo.1

      So basically I am trying to show a rolling 12mnth Avg based on what month my user selects so e.g

       

      Jan 2017 to Dec 2017 will Roll up into Dec 2017

      Feb 2017 to Jan 2018 will Rollup into Jan 2018

      March 2017 to Feb 2018 will rollup into Feb 2018.

       

      The issue I am having is that I am getting different values in sheet 1 & 2. I think its a straight forward fix but I just cant help scratching my head. Would appreciate assistance.