Oracle Message QSM-02003 - aggregate function nested within an expression

ERRORaggregate function nested within an expression
CAUSEThe capability in question is not supported when the materialized view contains an aggregate function invocation nested within an outer expression.
ACTIONRe-phrase the expression such that the aggregate function invocation is not nested.