5 Replies Latest reply on Dec 23, 2013 12:52 PM by William Edwards

    Average Percentages - Calculation not working

    William Edwards

      I'm doing some scorecarding and need a way to show the difference between yesterdays percent minus an 8-week trend. However, because volume fluctuates, I want to calculate an average of the percents. The Window_Avg function works well in calculating the average percentages only if I include dates as a part of the view. However, if you leave the date out of the view, which definitely want, it averages the raw values rather than the percents. Anyone have a work around for this scenario? Sample workbook is attached