I'm trying to build a report that shows credit loads for future semesters for students. The data is arranged something like this:

Record ID|Semester |Grade|Attempted Credits

(id)     |2018 Fall|     |3.0

Some students have manually changed credit loads, so they have grades "VC" (Variable Credit). The formula field I'm summing in the report is just:

If [Semester] = "2018 Fall" Then [Attempted Credits] Else 0

But then in the report, it only sums records where the Grade is not blank. I've tried things to isolate the blank grades and add them in ([Grade]="", IsNull{[Grade]}), but CR still doesn't seem to consider them. I've also checked the MDB file that it's based on to validate that the data is indeed there. It's just striking me as weird, because the [Grade] field isn't a key field, linked field, or referenced in any of the formulas or filters. It feels like if it disregarded records of people because their middle initial is blank.

The credit/grade data is all stored in one data. There are separate linked tables for student info, etc., but that's not involved in this particular calculation.

I just double-checked the database and verified that this table does include all grade records, regardless of whether or not the grade is blank/null, "VC", or a normal letter grade. So there's something in Crystal Report that's causing it to skip over the records with blank grades. Again, the grade field is not linked to any other tables, is not referenced in any formula (or group or selection formula), and is not marked as a key field. It's so weird!

Also in the formula field set the option to use 'default values for null'