ArithmeticException: "Non-terminating decimal expansion; no exact representable decimal result"

JavaBigdecimalArithmeticexception

Java Problem Overview


Why does the following code raise the exception shown below?

BigDecimal a = new BigDecimal("1.6");
BigDecimal b = new BigDecimal("9.2");
a.divide(b) // results in the following exception.

Exception:

java.lang.ArithmeticException: Non-terminating decimal expansion; no exact representable decimal result.

Java Solutions


Solution 1 - Java

From the Java 11 BigDecimal docs:

> When a MathContext object is supplied with a precision setting of 0 (for example, MathContext.UNLIMITED), arithmetic operations are exact, as are the arithmetic methods which take no MathContext object. (This is the only behavior that was supported in releases prior to 5.) > > As a corollary of computing the exact result, the rounding mode setting of a MathContext object with a precision setting of 0 is not used and thus irrelevant. In the case of divide, the exact quotient could have an infinitely long decimal expansion; for example, 1 divided by 3. > > If the quotient has a nonterminating decimal expansion and the operation is specified to return an exact result, an ArithmeticException is thrown. Otherwise, the exact result of the division is returned, as done for other operations.

To fix, you need to do something like this:

a.divide(b, 2, RoundingMode.HALF_UP)

where 2 is the scale and RoundingMode.HALF_UP is rounding mode

For more details see this blog post.

Solution 2 - Java

Because you're not specifying a precision and a rounding-mode. BigDecimal is complaining that it could use 10, 20, 5000, or infinity decimal places, and it still wouldn't be able to give you an exact representation of the number. So instead of giving you an incorrect BigDecimal, it just whinges at you.

However, if you supply a RoundingMode and a precision, then it will be able to convert (eg. 1.333333333-to-infinity to something like 1.3333 ... but you as the programmer need to tell it what precision you're 'happy with'.

Solution 3 - Java

You can do

a.divide(b, MathContext.DECIMAL128)

You can choose the number of bits you want: either 32, 64 or 128.

Check out this link :

http://edelstein.pebbles.cs.cmu.edu/jadeite/main.php?api=java6&state=class&package=java.math&class=MathContext

Solution 4 - Java

For fixing such an issue I have used below code

a.divide(b, 2, RoundingMode.HALF_EVEN)

2 is precision. Now problem was resolved.

Solution 5 - Java

I had this same problem, because my line of code was:

txtTotalInvoice.setText(var1.divide(var2).doubleValue() + "");

I change to this, reading previous Answer, because I was not writing decimal precision:

txtTotalInvoice.setText(var1.divide(var2,4, RoundingMode.HALF_UP).doubleValue() + "");

4 is Decimal Precison

AND RoundingMode are Enum constants, you could choose any of this UP, DOWN, CEILING, FLOOR, HALF_DOWN, HALF_EVEN, HALF_UP

In this Case HALF_UP, will have this result:

2.4 = 2   
2.5 = 3   
2.7 = 3

You can check the RoundingMode information here: <http://www.javabeat.net/precise-rounding-of-decimals-using-rounding-mode-enumeration/>

Solution 6 - Java

It´s a issue of rounding the result, the solution for me is the following.

divider.divide(dividend,RoundingMode.HALF_UP);

Solution 7 - Java

Answer for https://stackoverflow.com/questions/37926745/bigdecimal-throws-arithmeticexception

public static void main(String[] args) {
	    int age = 30;
	    BigDecimal retireMentFund = new BigDecimal("10000.00");
	    retireMentFund.setScale(2,BigDecimal.ROUND_HALF_UP);
	    BigDecimal yearsInRetirement = new BigDecimal("20.00");
	    String name = " Dennis";
	    for ( int i = age; i <=65; i++){
	        recalculate(retireMentFund,new BigDecimal("0.10"));
	    }
	    BigDecimal monthlyPension =   retireMentFund.divide(
	            yearsInRetirement.divide(new BigDecimal("12"), new MathContext(2, RoundingMode.CEILING)), new MathContext(2, RoundingMode.CEILING));      
	    System.out.println(name+ " will have £" + monthlyPension +" per month for retirement");
	}
public static void recalculate (BigDecimal fundAmount, BigDecimal rate){
	    fundAmount.multiply(rate.add(new BigDecimal("1.00")));
	}

Add MathContext object in your divide method call and adjust precision and rounding mode. This should fix your problem

Solution 8 - Java

Your program does not know what precision for decimal numbers to use so it throws:

java.lang.ArithmeticException: Non-terminating decimal expansion
Solution to bypass exception:
MathContext precision = new MathContext(int setPrecisionYouWant); // example 2
BigDecimal a = new BigDecimal("1.6",precision);
BigDecimal b = new BigDecimal("9.2",precision);
a.divide(b) // result = 0.17

Solution 9 - Java

For me, it's working with this:

BigDecimal a = new BigDecimal("9999999999.6666",precision);
BigDecimal b = new BigDecimal("21",precision);

a.divideToIntegralValue(b).setScale(2)

Attributions

All content for this solution is sourced from the original question on Stackoverflow.

The content on this page is licensed under the Attribution-ShareAlike 4.0 International (CC BY-SA 4.0) license.

Content TypeOriginal AuthorOriginal Content on Stackoverflow
QuestionJasonView Question on Stackoverflow
Solution 1 - JavaDVKView Answer on Stackoverflow
Solution 2 - JavaDavid BullockView Answer on Stackoverflow
Solution 3 - JavaMindBrainView Answer on Stackoverflow
Solution 4 - JavaPrahladView Answer on Stackoverflow
Solution 5 - JavaAlex Montenegro1987View Answer on Stackoverflow
Solution 6 - JavaJorge Santos NeillView Answer on Stackoverflow
Solution 7 - JavaPoorna ChanderView Answer on Stackoverflow
Solution 8 - JavaOjdaView Answer on Stackoverflow
Solution 9 - JavaAnh TaView Answer on Stackoverflow