That is because the first record probably has split_in <> "Y", so it is evaluating to 0...causing the width of the field to be 1. Try:

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

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