Filter or "where" statement for totals in report

[msmithtlh]

I am working on a report that is a transcript. I need to show all classes, but when calculating the semester GPA (in the subtotal) and the cumulative GPA (in the grand total) I need to have a calculation that adds the GPA shown for each record. Then divides that sum by the sum of the credits that showed a gradepoint (I don't divide by the sum of all credits).



The way I would put it in rough SQL is

sum(gradepoint)/sum(credits) where gradepoint is not null. However I can't figure out how to get this into the report format.

Here is a snapshot. In this example, I want to divide 16 gradepoints (total gradepoints) by 4 credits (the credits that have a gradepoint associated with them). Help will be greatly appreciated!!!

[msmithtlh]

I added a field to the table, which was populated only if the gradepoint was not null