Try nvl({quantityshiprecv},0)

thanks for the reply, but still same error

You might have to push your sums inside your case statement