2 Replies Latest reply on Oct 27, 2016 8:23 AM by rajul Parekh

    Weighted Average

    rajul Parekh

      Hi all - Struggling to understand how to write a calculation for a weighted average. Attached the workbook but basically need a vertical line to show the average number of pitches made. Should be straightforward but every time I write the following equation I get an error. I think it has to do with the count of last names (which is the count of people per number of pitches).




      Screen Shot 2016-10-26 at 3.48.35 PM.png

        • 1. Re: Weighted Average
          Santiago Sanchez

          Hi Rajul,


          Just looking at the formula, looks like the syntax is a bit off. Instead of:


          SUM([# Pitches] * COUNTD([What is your last name?]))/COUNTD([What is your last name?])


          This should work:


          (SUM([# Pitches]) * COUNTD([What is your last name?]))/COUNTD([What is your last name?])


          SUM and COUNTD are functions that aggregate data (the dimension or measure you put within parenthesis after the function name). On your formula, the SUM function was missing a parenthesis.


          Hope this helps!

          • 2. Re: Weighted Average
            rajul Parekh

            Hi Santiago - thanks so much for your help!


            Tried what you said but I'm not sure it's calculating correctly. The averages at the top of each bar don't seem correct... Also, I just need one average across ALL the columns. For example, I would guesstimate that the average is somewhere between 10-15 pitches.


            Does that make sense?


            Screen Shot 2016-10-27 at 11.21.41 AM.png