this is beginning to look better using
select iif(a.split_in="Y",a.price*a.catchweight,0)as T

but the result of the column is an asterik not price*catchweight.