Greetings,

I have the fololowing code:

If totext (({OELIN.UNITPRICE}),7)(6)) = 0 then 3 else 7

Basically I want to see if the value in position 6 of unitprice is zero; if so I assign a value of 3, otherwise I assign a value of 7, what I assign these values to is unimportant. My error message is that when checking syntax I get "The keyword THEN is missing" and it points between the right parenthesis near the 7 and the left parenthesis of the 6.

All help is appreciated.

Paul

Paul

__________________
Paul

If mid(totext({OELIN.UNITPRICE}),7,6) = 0 then '3' else '7'
this is the right formula