Dividing two fields (Big Decimal) . getting divide by zero error

RThammisetti9330 — Tue, 02 Aug 2022 20:22:28 GMT

Hi,

I just need to divide two fields which are defined as big decimal data type.

for example, receivables/sales. below is my actual rule. I am checking if the fields dont have zeroes in them. Below code is failing with "java.lang.ArithmeticException: / by zero". Can anyone help me please.

(row7.avgrecievables!=BigDecimal.valueOf(0) && row4.sales!=BigDecimal.valueOf(0) ) ?

row7.avgrecievables.divide(row4.sales, 3, BigDecimal.ROUND_HALF_UP) : new BigDecimal(0)

Re: Dividing two fields (Big Decimal) . getting divide by zero error

SamuelLenk — Tue, 25 Oct 2022 10:04:30 GMT

You have an AND (&&) check there for your two input columns, It should be OR (||) and it will work 😁

But still to check if your divisor is "0" you should rather do this:

(BigDecimal.ZERO.compareTo(input_row.bigDivisor) == 0) ? BigDecimal.ZERO : input_row.bigDividend.divide(input_row.bigDivisor)

HTH! Kind regards, Samuel

https://talend-training.com/

topic Dividing two fields (Big Decimal) . getting divide by zero error in Talend Studio

Dividing two fields (Big Decimal) . getting divide by zero error

Re: Dividing two fields (Big Decimal) . getting divide by zero error