1204707 - Rounding Precision of 16th Decimal places in Crystal Reports

• When using numbers or doubles in a calculation, the result might not always evaluate to 0 as expected.

Here is an example:

The above example provides an balancing calculation of two big debits which are being reduced by several smaller credits. The result is supposed to evaluate to 0.

• SAP Crystal Reports 2008
• SAP Crystal Reports 2011
• SAP Crystal Reports 2013
• SAP Crystal Reports 2016

Numbers / Doubles are both real floating-point number types, and are susceptible to roundoff errors. The problem is that floating point number values cannot be represented exactly in binary (eg. 1533.88). Crystal Reports is capable of having 15^th significant digits of decimal precision and so the value 1533.88 is represented accurate to 15 digits.

Likewise, this is the case for the values 1917.34. Note that both of these binary representations are approximations, with some roundoff error at the 16^th digit, because of the limitations of a 32bit floating point roundoff errors.

The result of the sum, which shows the remainder can be rounded. The following formula will enable the result to evaluate to 0:

     Round (Sum (DebitOrCredit)

 This calculation will round the total of the subtrations in the above example.

Rounding;Double;Number;Rounding;Precision , 7830542 , KBA , BI-RA-CR , Crystal Reports designer or Business View Manager , Problem

Crystal Reports 2008 V1 ; SAP Crystal Reports 2013 ; SAP Crystal Reports 2016 ; SAP Crystal Reports XI ; SAP Crystal Reports XI R2