How Divide BigDecimal value in ireport expression with validation

Asked Feb 06 '18 at 19:21

Active Feb 26 '18 at 16:45

Viewed 280 times

I have this expression in field:

$F{quartoAptoValorTotalLiberado} != new BigDecimal(0) &&
$F{quartoAptoValorTotalCobrado} != new BigDecimal(0)   ?

$F{quartoAptoValorTotalLiberado}.divide($F{quartoAptoValorTotalCobrado}, new MathContext(100))

:
new BigDecimal(0)

All fields defined have BigDecimal type.

I am using ireport version 3.0.0

When I use ireport, the compilation is successfully, but when I compile in java run debug I receive an error because this expression is incorrect.

I Can't reopened this question. I was solved programmatically inside iReport 3.0.0 with this code:

$F{dayClinicValorTotalLiberado} != BigDecimal.ZERO &&
$F{dayClinicValorTotalCobrado} != BigDecimal.ZERO    ?

$F{dayClinicValorTotalLiberado}.divide($F{dayClinicValorTotalCobrado}, new MathContext(100))

:

BigDecimal.ZERO

edited Feb 26 '18 at 16:45

asked Feb 06 '18 at 19:21

paulo.sobrinho

Side note: use [`BigDecimal.ZERO`](https://docs.oracle.com/javase/8/docs/api/java/math/BigDecimal.html#ZERO) – Juan Carlos Mendoza Feb 06 '18 at 19:24
Don't compare BigDecimal values using `!=, ==`. Use the [`compareTo`](https://docs.oracle.com/javase/8/docs/api/java/math/BigDecimal.html#compareTo-java.math.BigDecimal-)method. – Juan Carlos Mendoza Feb 06 '18 at 19:28
Thank You @JuanCarlosMendoza – paulo.sobrinho Feb 07 '18 at 12:14
How i sum values without use detail band? i need sum many fields of type BigDecimal – paulo.sobrinho Feb 07 '18 at 12:16

How Divide BigDecimal value in ireport expression with validation

0 Answers0