The zero at the end of the iff() is a problem...and I think that if either price or catchweight are wide enough to carry the result, there will be no problem with the middle portion of the iif().

>VFP tries to guess the width of the fields, so you must give VFP a clue.Try this

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

>
>>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.