Hello,
I have the following formula.
IF {BTable.Name} = "CMPS" THEN "Y"
ELSE "N"
The out put is .....
It should be a value 'N' in the second row under CMPS column.
Thank you for your help.
Hello
probably the field values is contains null. Can you use isnull() function to determine null values?
if (isnull({dbvalue}) or ({dbvalue} <> 'CMPS')) then "N" else "Y"
Regards,
János
Hello Janos,
Your formula works fine.
Thanks for your help.
-Bill