Dividing BigDecimal field by String field

[jbessmer]

Hi Everyone,

I'm a newbie and attempting to divide a BigDecimal field (bdfield) by a String field (strfield) in Jaspersoft Studio.

I've tried about 2 dozen approaches based on what I've read on these and other forums, but haven't been successful. Does anyone have a preferred approach?

Edit:  Here are some approaches I've tried:

$F{bdfield}.divide(Integer.parseInt($F{strfield})).setScale(2, RoundingMode.CEILING)

$F{bdfield}.divide(new Integer($F{strfield})).setScale(2, RoundingMode.CEILING)

$F{bdfield}.setScale(2, RoundingMode.CEILING) / new Integer($F{strfield})

$F{bdfield}.doubleValue() / new Double($F{strfield})

$F{bdfield}.doubleValue() / new Integer($F{strfield})

$F{bdfield}.doubleValue() / Double.parseDouble($F{strfield})

 

 

Here is the error on the last one:

Double.parseDouble cannot be resolved to a type value = ((java.math.BigDecimal)field_bdfield.getValue()).doubleValue() / new Double.parseDouble(((java.lang.String)field_strfield.getValue()));

 

Thanks for taking a look,

[gustavofarias]

you should put the expression that makes this calculation, and the error you are getting. Also, put 3 or 4 of the dozen things you tried.

[jbessmer]

thank you gustavofarias, I've added 6

[gustavofarias]

and the error? Is it compilation error ou runtime error?

[yama818]

I solved it with the following formula.

$F{bdfield}.divide( new BigDecimal($F{strfield})[/code]

I hope this is helpful.