Hello All - i am trying to forecast out data using actuals. I want to take the weighted average of the last three months of actual data (green box below) weighted by net auctionable (purple box below) and forecast out the rest of the year using this average. I setup a boolean row (red box below) in order to indicate which months I would like to average. So if we are working on row # 0, the formula would weighted average 10.97%, 10.03% and 8.43% and that number would be populated in the April 18 column and all future months after. Then we would move to row 1 and do the same thing with 23.45%, 23.45% and 28.43% weighted by net auctionable, and push out that number to April 18 and beyond.
I am having an issue anchoring the weighted averages to only the TRUE columns on the boolean row. Any help would be very very much appreciated. Thank you
... View more