Instead of
select iif(a.split_in="Y",a.price*a.catchweight,"")as T

You might want to try
select iif(a.split_in="Y",a.price*a.catchweight,0)as T