Skip to Content
avatar image
Former Member

IF statement does not work properly

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.

ifstatement.png (1.8 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    Feb 02, 2017 at 04:42 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Feb 02, 2017 at 05:16 PM

    Hello Janos,
    Your formula works fine.
    Thanks for your help.

    -Bill

    Add comment
    10|10000 characters needed characters exceeded