Crystal Reports rounding up

Technical Questions
Crystal Reports Forum : Crystal Reports 9 through 2020 : Technical Questions

Topic: rounding up

Author	Message
Tammyinct Newbie Joined: 07 May 2008 Location: United States Online Status: Offline Posts: 2	Topic: rounding up 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
	IP Logged

Tim Wise Newbie Joined: 29 Apr 2008 Location: United States Online Status: Offline Posts: 31	Posted: 07 May 2008 at 3:42pm
	Theorectically: - Divide by 10 - Truncate the fractional part - Add 1 - Multiply by 10
	-- Tim
	IP Logged

Lugh Senior Member Joined: 14 Nov 2007 Online Status: Offline Posts: 377	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.
	IP Logged

Tammyinct Newbie Joined: 07 May 2008 Location: United States Online Status: Offline Posts: 2	Posted: 08 May 2008 at 7:53am
	This worked. Thanks!
	IP Logged

Post Reply

Post New Topic

Printable version

Printable version

Forum Jump

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum

This page was generated in 0.031 seconds.