I was able to filter the - None - values by adding the following formula as a criteria to my search: CASE WHEN {name} IS NOT NULL THEN 1 ELSE 0 END This removed all transactions without a Name and prevented them from effecting all grand totals.