Simple If statement

[Joe1010]

This is very simple but I do not know it.
What is wrong with the if statement below?

if ({tableOne.fieldOne}) = "Y" then "Y"
else "n"

Thanks

 

[RobbieB]

Try taking out the () so it looks like this.

if {tableOne.fieldOne} = "Y" then "Y"
else "n

 

[Joe1010]

It returns Y if fieldOne = Y
However, if it is blank, it returns nothing.
The () did not make any change.

Thanks

 

[synapsevampire]

Try:

if isnull({tableOne.fieldOne})
or
trim({tableOne.fieldOne}) = ""
or
{tableOne.fieldOne} <> "Y" then
"N"
else
"Y"

-k

 

[RobbieB]

if the field is blank you have to account for this in your formula. It would be something like this

if isnull({tableOne.fieldOne})or {tableOne.fieldOne} = ""
Then "Not Indicated"
else if {tableOne.fieldOne} = "Y" then "Y"
else "n