Interpret Param to data code

[Former Member]

HI I have a column in the table which is + or - this means the item is available for sale or not.

The user wants however the parm sb Y or N.

Not sure what has to be coded on the record select.

[JWiseman · Accepted solution]

something like this should work

{yourfield} = (if {?yourparam} = 'Y' then '+' else '-')

[ido_millet · Accepted solution]

Or simply use Y and N as the Descriptions for the actual values, and set the parameter to show only Descriptions.

[Former Member · Accepted solution]

I get a error message that the remaining text does not appear to be part of the formula.

{ICPRT1.IAACTF} = (if {?Avail for sale} = 'Y' then '+' else '-')

[JWiseman · Accepted solution]

this syntax works fine for me in a record selection formula (using a different field than the iaactf.) the error would stem from somewhere else in your record selection.

[DellSC · Accepted solution]

I like Ido's suggestion.  However, another way to do it would be something like this:

(

({?Avail for sale} = 'Y' and {ICPRT1.IAACTF} = '+')

or

({?Avail for sale} = 'N' and {ICPRT1.IAACTF} = '-')

)

Notice where the parentheses are - they are required in order to get this working correctly.

-Dell