[How to sum double datatype when the column contains null value]

Hi All,

My report looks like below

Apr,May,Jun    ,July ,Total

null,null,120.00,null , null

I have created the variable for Sum and in Expression I have mentioned as $F{Apr}+$F{May}+$F{Jun}+$F{Jul}, in Total I am getting null value.

I can understand that if we have null values in other column result will be null, how to validate the double type with null and how to calculate the total?

 

Regards,

Chakravarthy

[How to Create Java based data entry form in Jaspersoft?]

Hi Elizam,
Thanks for reply, is it not possible by using Java Code?

 

[How to Create Java based data entry form in Jaspersoft?]

How can I create a Java based data entry form in Jaspersoft, I need to enter the data once I click on submit then data need to submit into the database.

Is it possible in Jaspersoft?