Expression return null

[jbreuil]

hello,

I have this expression  :   IF($F{GENDER}=="Men",1,0)  the field is a string 

I have the option calculation on "sum"  and the value class name on "java.lang.Integer" , but every time i go preview it return me null

 

Can you help please

 

thank you

[bolsover]

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