1481313 - Different values obtained when rounding is applied to formula in Crystal Reports 2008 vs Crystal Reports XI Release 2

SAP Knowledge Base Article - Public

1481313 - Different values obtained when rounding is applied to formula in Crystal Reports 2008 vs Crystal Reports XI Release 2

Symptom

  • Incorrect result displayed in Crystal Reports 2008 Service Pack 2 (CR 2008 SP2)
  • Rounding off the following formula displays -18,409 which is the wrong result

(5890.50 - 24300.00)/abs(24300.00)*24300 

Environment

  • Crystal Reports 2008 Service Pack 2 (CR 2008 SP2)
  • Crystal Reports XI Release 2 SP2 (CR XI R2 SP2)

Reproducing the Issue

  • In CR XI R2 SP2, create the following formula:

(5890.50 - 24300.00)/abs(24300.00)*24300 

  • Drag the formula in the report and preview the result
  • Using Format field/Decrease decimal icon, round the result to the nearest whole number and preview

Note: -18,410 is displayed

  • Repeat the above step in CR 2008 SP2

Note: -18,409 is displayed

Resolution

Edit the formula in CR 2008 SP2 and change it to: 

Round ((5890.50 - 24300.00)/abs(24300.00)*24300)

Keywords

KBA , BI-RA-CR , Crystal Reports designer or BusinessViews Manager , Problem

Product

Crystal Reports 2008 V1 ; SAP Crystal Reports XI R2