variable expression not working in ireport 3.7.4

[bentong]

(($F{field1}.doubleValue() +  $F{field2}.doubleValue() + $F{field3}.doubleValue() + $F{field4}.doubleValue() +               $F{field5}.doubleValue())/5)

Post Edited by paltakmo at 08/10/2010 09:39

[bentong]

is this a bug of ireport 3.7.4 or my expression is not correct?

[dnewsom]

What is happening with the issue? The variable looks like it could work depending on the values of the fields.

[robsil]

new Double(($F{field1}.doubleValue() +  $F{field2}.doubleValue() + $F{field3}.doubleValue() + $F{field4}.doubleValue() +               $F{field5}.doubleValue())/5))

 Edit:  Actually you shouldn't trust the values to be non-null... so....

new Double(

($F{field1} == null?0.0:$F{field1}.doubleValue()) +

($F{field2} == null?0.0:$F{field2}.doubleValue()) +

($F{field3} == null?0.0:$F{field3}.doubleValue()) +

($F{field4} == null?0.0:$F{field4}.doubleValue()) +

($F{field5} == null?0.0:$F{field5}.doubleValue())

)

Post Edited by robsil at 08/10/2010 19:07