Minus function issue on Decimal numbers

[karthi djax]

Hi,

Am facing below issue while while doing minus in query

Code: 43. DB::Exception: Received from localhost:9000. DB::Exception: Illegal types Float64 and Decimal(38, 8) of arguments of function minus: While processing paid - spend AS month. (ILLEGAL_TYPE_OF_ARGUMENT)

Round((Sum(paid) - Sum(spend)),4) AS balance, - syntax used.

Can anyone guide me on this.

Regards,

Karthik