bolsover
-
Posts
59 -
Joined
-
Last visited
Community Answers
-
bolsover's post in Expression return null was marked as the answer
Instead of using the IF() function and assuming you are using Java as the language you could try:
$F{GENDER}.trim().equals("Men") ? 1 : 0
The IF() function will always return null when the argument is null.
To modify my suggestion to account for null values, you would need something like:
$F{GENDER} != null && $F{GENDER}.trim().equals("Men") ? 1 : 0 db