Else???? 1

[mikefortune]

I keep trying an if then else and it keeps telling me "a number is required here" when I check it.
here is the formula:

If {OELIN.Itemkey} <> &quot;FREIGHT&quot;
and {OELIN.Qtyord} >= 1
then {OELIN.Qtyord}
else
IF {OELIN.Itemkey} = &quot;FREIGHT&quot;
then &quot;&quot;

 

[marckssg]

I think thats because you can't refer to both a string field and numeric field within the same formula.

Every time you want to reference the {OELIN.Qtyord} field insert it as follows:

totext({OELIN.Qtyord} )

this should then work ok.

Cheers

Marc

 

[mikefortune]

You are correct sir! THanks, I found it 2 minutes after posting this. Thanks a ton, you had the right answer!!!!