<div>
By the way I want to Round to 2 decimal places.
</div>


By the way I want to Round to 2 decimal places.

<div>
can you please post an example;<br />
<br />
gary
</div>


<div>
<br />
The &nbsp;function in excel is like this: Roundup(number, numberofDigitstoRound)<br />
<br />
Roundup(0.1470, 2) = 0.15<br />
<br />
Roundup(0.1838, 2) = 0.19<br />
<br />
Roundup(2.1840, 2) = 2.19<br />
<br />
Roundup(1, 2) = 1
</div>



The  function in excel is like this: Roundup(number, numberofDigitstoRound)

Roundup(0.1470, 2) = 0.15

Roundup(0.1838, 2) = 0.19

Roundup(2.1840, 2) = 2.19

Roundup(1, 2) = 1

<div>
Try this<br />
<br />
Round({YourNumber} + .005, 2)<br />
<br />
mlmcc
</div>


Try this

Round({YourNumber} + .005, 2)

mlmcc

<div>
Thanks mlmcc, but when the following the number is 0 it rounds it up to 0.01 and it should be equal to 0.<br />
<br />
In excel: &nbsp;Roundup(0,2) = 0<br />
<br />
Any idea?
</div>


Thanks mlmcc, but when the following the number is 0 it rounds it up to 0.01 and it should be equal to 0.

In excel:  Roundup(0,2) = 0

Any idea?

<div>
I did something like this:<br />
<br />
if Number= 0 then <br />
&nbsp; &nbsp; formula = 0<br />
<br />
else <br />
formula = Round( Number + .005, 2)<br />
<br />
end if<br />
<br />
<br />
----------------<br />
Does that look right?
</div>


I did something like this:

if Number= 0 then
    formula = 0

else
formula = Round( Number + .005, 2)

end if


----------------
Does that look right?

<div>
Now I noticed a problem, when the number is 9.4500 it rounds it to 9.46 when it should be 9.45
</div>


Now I noticed a problem, when the number is 9.4500 it rounds it to 9.46 when it should be 9.45

<div>
Glad i could help<br />
<br />
mlmcc
</div>


<div>
<div class="content wysiwyg-content">
Hi all.<br />
<br />
I want to use the RoundUp function that is used in Excel (Rounds a number up, away from 0) in Crystal Reports, but it does not work.<br />
<br />
Is there a similar function, if not, how do I get Crystal to round up?<br />
<br />
Thank you in advance.
</div>
</div>


Hi all.

I want to use the RoundUp function that is used in Excel (Rounds a number up, away from 0) in Crystal Reports, but it does not work.

Is there a similar function, if not, how do I get Crystal to round up?

Thank you in advance.

Is there a RoundUp function in Crystal Reports?

Crystal Reports is a business intelligence application from SAP SE. It is used to graphically design data connections and report layouts from a wide range of data sources including Excel spreadsheets, Oracle, SQL Server databases and Access databases, BusinessObjects Enterprise business views, and local file-system information. Report designers can place fields from these sources on the report design surface, and can also deploy them in custom formulas (using either BASIC or Crystal's own syntax), which are then placed on the design surface. Crystal Reports also supports subreports, graphing, and a limited amount of GIS functionality.