Print Page | Close Window

rounding up

Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2020
Forum Name: Technical Questions
Forum Discription: Formulas, charting data, Crystal syntax, etc.
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=3131
Printed Date: 04 May 2024 at 2:12am


Topic: rounding up
Posted By: Tammyinct
Subject: rounding up
Date Posted: 07 May 2008 at 3:00pm
I am having problems rounding up in crystal ver 8.5.  I want to round whole numbers up to the nearest 10.  Example I have 104 and need it to round to 110.  Not all numbers are 3 digits.  I'm sure there is a simple way to do this I can not figure it out.  In excel it is roundup not sure of the fomula in crystal.  Any help would be greatly apreciated.
 
Tammy


Replies:
Posted By: Tim Wise
Date Posted: 07 May 2008 at 3:42pm

Theorectically:
- Divide by 10
- Truncate the fractional part
- Add 1
- Multiply by 10
 


-------------
--
Tim

Posted By: Lugh
Date Posted: 08 May 2008 at 6:12am
Or you could, you know, use the Ceiling function.

Ceiling({MyReport.MyField},10)

It's a little bit simpler.

Posted By: Tammyinct
Date Posted: 08 May 2008 at 7:53am
This worked.  Thanks!


Print Page | Close Window