Forum Discussion
dyingod
Helper I
Helper IAdWords avg. position calculation
Hello, Super newbie here... so this might be a really easy one. Regardless of whether or not you know AdWords, to calculate Average position in Excel, one can just do the following formula: ...
Perfect, I created a column using this formula:
WeightedAverage = ([Impressions] * [Avg. position]) / [Impressions]
I also created a measure like this:
mWeightedAverage = (SUM(Sheet2[Impressions]) * AVERAGE(Sheet2[Avg. position])) / SUM(Sheet2[Impressions])
Greg_Deckler
Community Champion
Community ChampionSeems like a straight-forward calculation, what kind of error are you seeing? Any chance you can post sample data?