Conditional Expression

[fkmfkm]

Can I do something like this in a Text Object ?

if {Table.Field} = 'A' then
'Active'
Else If {Table.Field} = 'X' Then
'Dead'
Else
'Unknown'

[Alex K.]

Hello,

Please try to use the following text expression:

Code: Select all

{IIF(Table.Field == "A", "Active", IIF(Table.Field == "X", "Dead", "Unknown"))}

Thank you.

[fkmfkm]

Yup thats working...

Just another twist...can I code like this ? Don't really like the long long code.

{IIF(Table.Field == "A", "Active", "")}
{IIF(Table.Field == "X", "Dead", "")}

[HighAley]

Hello.

You will get empty fist line if Field is not A.
It's better to use Switch function.

Thank you.