Solved

Is there a RoundUp function in Crystal Reports?

Posted on 2007-04-03
10
1,612 Views
Last Modified: 2010-05-18
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.
0
Comment
Question by:printmedia
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 6
  • 3
10 Comments
 

Author Comment

by:printmedia
ID: 18845699
By the way I want to Round to 2 decimal places.
0
 
LVL 13

Expert Comment

by:crgary_tx
ID: 18845727
can you please post an example;

gary
0
 

Author Comment

by:printmedia
ID: 18845815

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
0
Enroll in May's Course of the Month

May’s Course of the Month is now available! Experts Exchange’s Premium Members and Team Accounts have access to a complimentary course each month as part of their membership—an extra way to increase training and boost professional development.

 
LVL 100

Expert Comment

by:mlmcc
ID: 18845981
Try this

Round({YourNumber} + .005, 2)

mlmcc
0
 

Author Comment

by:printmedia
ID: 18846099
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?
0
 

Author Comment

by:printmedia
ID: 18846128
I did something like this:

if Number= 0 then
    formula = 0

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

end if


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

Author Comment

by:printmedia
ID: 18846200
Now I noticed a problem, when the number is 9.4500 it rounds it to 9.46 when it should be 9.45
0
 
LVL 100

Accepted Solution

by:
mlmcc earned 500 total points
ID: 18846260
Try
Round( Number + .0049, 2)

mlmcc
0
 

Author Comment

by:printmedia
ID: 18846434
worked great!
0
 
LVL 100

Expert Comment

by:mlmcc
ID: 18847606
Glad i could help

mlmcc
0

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

There have always been a lot of questions related to when Crystal Reports evaluates report components (such as formulas, summaries, cross-tabs, charts, to name a few examples). Crystal Reports uses a two-pass reporting process to provide greater …
Hello everyone, Hope you find this as helpful as we did. We have on the company I work for an application built in Delphi V with Crystal Reports 8. We all know that Crystal & Delphi can be temperamental sometimes and the worst thing is, nearly…
Nobody understands Phishing better than an anti-spam company. That’s why we are providing Phishing Awareness Training to our customers. According to a report by Verizon, only 3% of targeted users report malicious emails to management. With compan…
Suggested Courses

734 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question