added a test for aggregate sum to default to zero when no terms are found