Forum Discussion

dyingod's avatar
dyingod
Helper I
9 years ago
Solved

AdWords 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: ...
Need Help
  • Greg_Deckler's avatar
    Greg_Deckler
    9 years ago

    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's avatar
Greg_Deckler
Community Champion
9 years ago

Seems like a straight-forward calculation, what kind of error are you seeing? Any chance you can post sample data?

  • dyingod's avatar
    dyingod
    Helper I
    9 years ago

    Hey smoupre! Thanks for answering the call!

     

    What sort of data do you need? Here is a screenshot of the table I am trying to plug this as a Mesure:

     

    If you need anything else let me know! More than happy to supply!