Problem with BigDecimal variable calculation

[nitin403]

Hi, All.

I have a text field called "ProjectAmount", which holds a String value.

 

I want the total of this field in the column footer.

 

So created a variable called "TotalPro".

the expression is

new BigDecimal($F{ProjectAmount})

This works fine.

But if ProjectAmount is "" or null the report fails.

 

In this report if such a condition comes then it should ignore this, and continue with rest of the report.

I was not able to formulate the correct equation.

 

Thanks for your help in advance.

[martynhiemstra]

Set the expression to

 

Code:

($F{ProjectAmount} != null && !"".equals($F{ProjectAmount}) ? new BigDecimal($F{ProjectAmount}) : new BigDecimal(0) 

Post edited by: martynhiemstra, at: 2007/11/30 07:00

[nitin403]

Thanks a lot it worked out perfectly.

Thanks martynhiemstra.