Minus function issue on Decimal numbers

6 views
Skip to first unread message

karthi djax

unread,
Apr 16, 2022, 5:08:07 AMApr 16
to ClickHouse
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
Reply all
Reply to author
Forward
0 new messages