topic Re: [resolved] How to devide a BigDecimal value... in Talend Studio

[resolved] How to devide a BigDecimal value...

Anonymous — Sat, 16 Nov 2024 12:55:27 GMT

Hi *,
using tMap, I'm trying to devide a BigDecimal vaule by 100. Pretty simple, I thought.
Source and target fields are BigDecimal, but by using the following syntax I get an error like: "Exception in component tRowGenerator_1" by clicking the 'Test'-Button in the expression editor of the target field.

new BigDecimal(100).divide(row1.theUltimateValueWhoNeedsToGetDevidedBySomething)

What is the mistake?
Thank you!
Ben

Re: [resolved] How to devide a BigDecimal value...

Anonymous — Fri, 13 May 2011 08:43:19 GMT

Here is the error I get by running the job:

no exact representable decimal result.
at java.math.BigDecimal.divide(Unknown Source)

Re: [resolved] How to devide a BigDecimal value...

Anonymous — Fri, 13 May 2011 11:15:34 GMT

Is nobody able to help me out on this issue?

Re: [resolved] How to devide a BigDecimal value...

Anonymous — Fri, 13 May 2011 11:38:22 GMT

Hi
use
new BigDecimal(100).divide(row1.theUltimateValueWhoNeedsToGetDevidedBySomething,RoundingMode.HALF_UP)

Re: [resolved] How to devide a BigDecimal value...

Anonymous — Fri, 13 May 2011 12:12:33 GMT

Thank you!
But now Talend is telling me that 'RoundingMode' cannot get resolved... Would it be better to change the data type into double or something like that?

Re: [resolved] How to devide a BigDecimal value...

Anonymous — Fri, 13 May 2011 12:24:06 GMT

Hi
Sorry i didnt give fully
write java.math.RoundingMode.HALF_UP instead of RoundingMode.HALF_UP

Re: [resolved] How to devide a BigDecimal value...

Anonymous — Fri, 13 May 2011 13:07:27 GMT

Hey Lijo,
thank you for your help! You pushed me into the right direction!
I found a second problem in my syntax: I muddled up the source value and the division value; for example:
100 divided by 15 (false)
instead of
15 divided by 100 (correct)

So the code is now working, I just needed to swap those values in the code, thanks again!

row4.MWST_SATZ.divide(new BigDecimal(100),java.math.MathContext.DECIMAL32)