Can't summarize calculated field in a Pivot Table

I have a pivot table with two Calculated Fields and two rows based off a table. When I right click the Pivot Table and do "Summarize Data by" I select "Average" and it creates an Average column. However, one of my Calculated Fields is still a Total, not an Average.

I looked around, and someone suggested to right click the Calculated Field and go to "Value Field Settings" and select "Average" from that box. I did that, but nothing changed, it's still a total and not an average.

How can I get this last column to be an average like the others?

"Total Exams" and "Percentage STAT" are calculated fields.

See picture:
excel-calculated-field1.JPG

Hi there,

Can you please attach your excel workbook.

Thanks

Vishnu