NULL Calculation ?

[runner1549]

How can I get the below to work when one value is null ?

-------------------------------------------------------------------------------------

Example

 1. COMP_PERC_1 = 10

 2. CAT_PERC_1 = NULL

 3. below display NULL, but should really display "10"

             new Double($V{COMP_PERC_1}.doubleValue() + $V{CAT_PERC_1}.doubleValue())

[walmillard]

Try adding a null condition to the output... in the case below the Field element will print the value of the COMP varable in case of CAT_PERC_1 == null

$V{CAT_PERC_1}==null? new Double($V{COMP_PERC_1}.doubleValue()): new Double($V{COMP_PERC_1}.doubleValue() + $V{CAT_PERC_1}.doubleValue())

Luck!

Code:

$V{CAT_PERC_1}==null? new Double($V{COMP_PERC_1}.doubleValue()): new Double($V{COMP_PERC_1}.doubleValue() + $V{CAT_PERC_1}.doubleValue())

[runner1549]

Thanks, below worked

 

new Double(($V{COMP_PERC_1}!=null?$V{COMP_PERC_1}.doubleValue():0)+ ($V{CAT_PERC_1}!=null?$V{CAT_PERC_1}.doubleValue():0))[/code]