1 Reply Latest reply on May 17, 2017 11:24 AM by Yemeng Hu

    How can I create a variable that only calculates the moving average based on the end of the month?

    Jeremy Miraglia

      The title kind of says it all - I am trying to do a moving average calculated once at the end of the month (i.e.) on 12/31/2017, I want the moving average for the month to be 90 days (including 12/31/2017) on that date. Is there also a way to make moving averages work for WAVG calculations?

       

      Thanks.