11.2. Exact Math

This section describes functions that can be used to do high precision arithmetic.

11.2.1. Handle BigInteger And BigDecimal

Statement Description Return type

RETURN apoc.number.exact.add(stringA,stringB)

return the sum’s result of two large numbers

string

RETURN apoc.number.exact.sub(stringA,stringB)

return the substraction’s of two large numbers

string

RETURN apoc.number.exact.mul(stringA,stringB,[prec],[roundingModel]

return the multiplication’s result of two large numbers

string

RETURN apoc.number.exact.div(stringA,stringB,[prec],[roundingModel])

return the division’s result of two large numbers

string

RETURN apoc.number.exact.toInteger(string,[prec],[roundingMode])

return the Integer value of a large number

Integer

RETURN apoc.number.exact.toFloat(string,[prec],[roundingMode])

return the Float value of a large number

Float

RETURN apoc.number.exact.toExact(number)

return the exact value

Integer

  • Possible 'roundingModel' options are UP, DOWN, CEILING, FLOOR, HALF_UP, HALF_DOWN, HALF_EVEN, UNNECESSARY

The prec parameter let us to set the precision of the operation result. The default value is 0 (unlimited precision arithmetic) while for 'roundingModel' the default value is HALF_UP. For other information abouth prec and roundingModel see the documentation of MathContext

For example if we set as prec 2:

RETURN apoc.number.exact.div('5555.5555','5', 2, 'HALF_DOWN') as value;
Table 11.9. Results
Value

1100

As a result we have only the first two digits precise. If we set 8 we have all the result precise

RETURN apoc.number.exact.div('5555.5555','5', 8, 'HALF_DOWN') as value;
Table 11.10. Results
Value

1111.1111

All the functions accept as input the scientific notation as 1E6, for example:

RETURN apoc.number.exact.add('1E6','1E6') as value;
Table 11.11. Results
Value

2000000

For other information see the documentation about BigDecimal and BigInteger