Can't Determine Average Based on a Summary Field
When I changed the original summary field (to add up each student's grants) to a calc field, it stopped working, because Sum (amount) only showed the total for each grant, not for all grants received by each student.
How should I approach this? I'm stumped. I read about using GetSummary, but I couldn't get it to work. No matter how I try to define the average, it comes back as an average of each student's grants, not all students' grants.