SAP Knowledge Base Article - Public

1206375 - How to round a number up in Crystal Reports XI

Symptom

How do I round a number up in Crystal Reports XI?

Cause

In Crystal Reports XI, it is necessary to round a number up (for example, rounding 10.2 up to 11).

The round function does not produce the desired result as it rounds the number to the nearest whole number (for example, 10.2 rounds to 10).

Resolution

Add .499999999 to the number, and then round the result.

Keywords

rounding up , 9113739 , KBA , BI-RA-CR , Crystal Reports designer or Business View Manager , Problem

Product

SAP Crystal Reports XI ; SAP Crystal Reports XI R2