In the Crystal Reports 2008 Designer, customized formulas that are set to round number fractions to their nearest whole number may round whole numbers instead of fractions.
If we set the formula directly as :Round( (5890.50 - 24300.00)/abs(24300.00)*24300).
Preview the field, the data show as -18,409.00. this is incorrect. The correct data should be -18,410.00
Crystal Reports 2008 Designer
Reproducing the Issue
- Create a formula in formula workshop:(5890.50 - 24300.00)/abs(24300.00)*24300
- Right click on the field and select "format field"
- In "Number" tab. click "Customize"
- In the dropdown list of "Rounding",select 1 to round it to the nearest whole number or decrease the decimal place to the nearest whole number using the icon from the menu.
This issue has been identified as a bug and raised under Problem Report ID: ADAPT01439629.
This issue has been addressed in SAP Crystal Reports 2011 Feature Pack 3.
crystal reports, customized formulas, round number, fractions, whole numbers , KBA , BI-RA-CR , Crystal Reports designer or Business View Manager , Bug Filed