Oracle Solution for Error ora-36170

Solution for Oracle Error ORA-36170

ORA-36170: (XSMXAGGR12) The data type of the WEIGHT workspace object

must be numeric or BOOLEAN, not string

.

What triggered the Error:

The user specified a WEIGHT variable or formula which wasn't numeric or boolean

What should we do to fix it:

Specify a numerical or boolean weight instead