Null and duplicate values specified by value_expression are eliminated from the computation for the group.