Correlated references in aggregate functions must not be in
  expressions

  Explanation:  You cannot use a correlated reference that is part
  of a value expression containing comparison operators, when the
  value expression is itself an argument to an aggregate function.
  For example, SUM(corr_reference + 5).

  User Action:  Reformulate the select expression to avoid using a
  correlated reference in this manner.