Simple IIF not executing the Else statement

[redeemasp]

I use:

IIF ({ORC_get_O07MarketingLead.Description} = 'Marketing Lead', "Yes", "No")

When variable is other than Marketing Lead, the second part of the statement (else) does not perform.

So I get either Yes, or Blank (instead of No). Any ideas?

Thanks

Redeem

 

[lbass]

I don't think the iif function (in CR) works well with nulls. Try using:

if isnull({ORC_get_O07MarketingLead.Description}) or
{ORC_get_O07MarketingLead.Description} <> "Marketing Lead" then "No" else "Yes"

-LB