Hi,

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

You're trying to put data of two different types into the same column. You probably want to make the last parameter 0 not ""

HTH,
Viv