1 Reply Latest reply on Oct 7, 2013 11:51 AM by Matt Lutton

    Calculating the Percentage of two Columns

    Kurt Heisler

      I suspect I'm missing something obvious.

       

      I would like to create a third column that shows the row percentage, where % = Column C / B. The percentage should automatically update based on the level of aggregation selected.

       

      For example:

       

      When school is the only level of aggregation, Percent Graduating should equal what's shown below:

       

      SchoolNumber of StudentsNumber GraduatingPercent Graduating
      Smith Elementary1007070%
      Jones Middle50010020%

       

      When Grade is added, Percent Graduating should update to show the percent for each grade, for each school. (Again, just a simple row percentage.)

       

      SchoolGradeNumber of StudentsNumber GraduatingPercent Graduating
      Smith ElementaryKinder302010%
      Smith Elementary1st402050%
      Smith Elementary2nd3030100%
      Jones Middle4thetc.
      Jones Middle5th
      Jones Middle6th

       

      I've tried multiple ways and can't get it to calculate correctly.


      Thank you.

        • 1. Re: Calculating the Percentage of two Columns
          Matt Lutton

          sum([Number Graduating]) / sum([Number of Students]) should get you there--when you say you've tried multiple ways and can't get it to calculate correctly, can you specify what you've tried and where it falls short?  Of course, a packaged workbook that demonstrates the problem would be ideal, or even screenshots of the results you are seeing will be helpful in obtaining the best possible help from forum members.