The Result of selection formula must be a boolean

[rwn]

I have this basic formula:
if {@SalesCode} = "NA"
then {Job.Sales_Code}
else {Job.Sales_Code} = {@SalesCode}

the formula is a String and so is the Field of the table Job.

However, it errors and states: ....The Result of selection formula must be a boolean......

Thank you for any assistance!!

 

[nobull613]

I believe that you need to set the Sales_Code field equal to something. If you're trying to get it to return all Sales_Code records if the user enters "NA" then you may need to try:

if {@SalesCode} = "NA"
then {Job.Sales_Code} like "*"
else {Job.Sales_Code} = {@SalesCode}

 

[rwn]

Thank you very much. That was the issue!!!