Variable Expressen String to Double

[shining01]

Hello,

i use Jasperreports 5.2 and iReport 5.5.0. I have to String Fields with numeric values. i would like to calculate this two fields in one variable.

My Variable expression is:

new Double($F{SUMMEBESTELLMENGE}.toDouble()-$F{BESTAND}.toDouble())

Fehler: Error evaluating expression :
    Source text : new Double($F{SUMMEBESTELLMENGE}.toDouble()-$F{BESTAND}.toDouble())

The Report Language is groovy.

i have tried also Double.valueOf(Double.valueOf($F{SUMMEBESTELLMENGE}).doubleValue()*Double.valueOf($F{BESTAND}).doubleValue()). but also with error.

 

I call the report in my Java Programm.

[sambitgudu]

Change report language type to JAVA

[shining01]

Hello everybody,

 

i have found my mistake. There was a null value. Now it works with this syntax:

$V{SumErwarteterZugang}-(($F{BESTAND} == null || $F{BESTAND}.length()<=0)?new Double(0.0):Double.parseDouble($F{BESTAND}))-(($F{SUMMEBESTELLMENGE} == null || $F{SUMMEBESTELLMENGE}.length()<=0)?new Double(0.0):Double.parseDouble($F{SUMMEBESTELLMENGE}))

 

Thanks