Here is what I'm trying to do. Feel like this is probably easy and I'm just missing a step somewhere or if what I'm trying to do is not mathematically correct

I attached an example of the current gradebook as a reference.

I have a class with 1 sub-category so far. This subcategory is doing exactly what I want - adding up all the points the student has earned (273) and dividing by the number of points possible (257 - one item was extra credit), while excluding any assignment that does not have a grade. On the right track up to this point...

The student has earned grades in two items which have not yet been put into a sub-category (40 points earned on two assignments which were worth a total of 56 points)

When I look at the course total it shows the 313 points the student has earned thus far (which is correct) but its dividing by the total number of points in the course (2890). This causes the percent to be 11%. While this calculation is correct, I want the course total to do what the sub-category is doing - divide only by the total points for those items which the student has a grade (basically I want a aggregate only non-zero items). So it would be 313 divided by 313 points possible for the assignments thus far- to give the student 100%

I have tried each of the aggregation types and those didnt do it. What am I missing?

Thanks! You all are much smarter than me about this!