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.