8 Replies Latest reply: May 30, 2011 11:08 AM by Yonatan landau RSS

    Moving Average - what to do w the first 20 days?

      I've successfully added a 20-day moving average line to my chart; however the first twenty days are calculating the average based upon only the selected data so they're not a true mvg avg (meaning Day 1's mvg avg= D1 sales, D2 mvg avg= D1+D2 sales/2, etc).

      The data I need to do the calcuation is loaded...I just can't figure out the set analysis (or any other solution) needed to base the mvg avg calculation on days that are excluded from the current selection.