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