Crystal Reports Formula to Round to Nearest Multiple of 5

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

Topic: Formula to Round to Nearest Multiple of 5

Author	Message
waterg2 Newbie Joined: 29 Oct 2010 Online Status: Offline Posts: 10	Topic: Formula to Round to Nearest Multiple of 5 Posted: 18 Nov 2010 at 5:52am
	I'm trying to build a formula that rounds the value to the nearest multiple of 5. Example 1: value is 316, would be rounded to 315. Example 2" value is 318, would be rounded to 320. Is this possible? Any help would be greatly appreciated.
	waterg2
	IP Logged

DBlank Moderator Joined: 19 Dec 2008 Online Status: Offline Posts: 9053	Posted: 18 Nov 2010 at 6:06am
	try: mround(field,5)
	IP Logged

waterg2 Newbie Joined: 29 Oct 2010 Online Status: Offline Posts: 10	Posted: 18 Nov 2010 at 6:40am
	Thank you very much !!!! That seems to be working.
	waterg2
	IP Logged

waterg2 Newbie Joined: 29 Oct 2010 Online Status: Offline Posts: 10	Posted: 18 Nov 2010 at 8:11am
	Question - We use version 8.5 and 11.5, as the newer version is not support by one of our vendors. I noticed the MRound(field,5) function is not available in 8.5...but is in 11.5. Is there another work around we could use in 8.5 to arrive at the same result?
	waterg2
	IP Logged

DBlank Moderator Joined: 19 Dec 2008 Online Status: Offline Posts: 9053	Posted: 18 Nov 2010 at 8:15am
	haev not used that version so I am not sure what else would work in it. Anyone else that knows 8.5?
	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.063 seconds.