SAP Knowledge Base Article - Preview

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

Symptom

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

Here is an example:

1533.880000000000000
1
1533.880000000000000
1917.340000000000000
1
1917.340000000000000
127.820000000000000
-1
-127.820000000000000
127.820000000000000
-1
-127.820000000000000
127.820000000000000
-1
-127.820000000000000
127.820000000000000
-1
-127.820000000000000
127.820000000000000
-1
-127.820000000000000
312.460000000000000
-1
-312.460000000000000
312.460000000000000
-1
-312.460000000000000
312.460000000000000
-1
-312.460000000000000
312.460000000000000
-1
-312.460000000000000
312.460000000000000
-1
-312.460000000000000
312.460000000000000
-1
-312.460000000000000
312.460000000000000
-1
-312.460000000000000
312.460000000000000
-1
-312.460000000000000
312.440000000000000
-1
-312.440000000000000
      Remainder
 
-0.000000000000796
 

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.

 


Read more...

Environment

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

Product

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

Keywords

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

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.