Crystal Reports Formula Error

[adsc]

Dear All,
When I type this formula in the formula editor
<pre>
if {AN_PaymentDtl.ServiceType} = "N" then "New" else "Old"
</pre>

I get this error:
“The result of selection formula must be a Boolean”

Thank u for the help

[Lunatic3]

The error says it all. In some cases you should use a True/False formula, and this seems to be the case. Where are you using your formula?

[adsc]

Lunatic3, thank you for your reply.

I am using the formula inside the CR report in one of the feilds, I selected the filed then selected the "Select Expert", then selected "Formula".
This field contain one of 2 letters only, "N" for "new" and "O" for "Others", so I want the report to check if it's "O" or "N" then will print the related word in the report.

[adsc]

I shouldn't select "Select Expert" option, I should create a new formula with the condition I want, then replace it in the report.

Thanks for the help.

[Lunatic3]

I was just writing that
Also you may write your formula like this:
IIF ({AN_PaymentDtl.ServiceType} = "N" ,'NEW" ,"Old" )

[adsc]

I'll try it....

Thank you for your help