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

# Calculating the Percentage of two Columns

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:

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.)

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

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.