Active TopicsMemberlistSearchHelpRegisterLogin

Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Report Design
Message Icon Topic: Rounding to "Nearest...." Post Reply Post New Topic
Author Message
cmainard
Newbie
Newbie
Avatar

Joined: 22 Jul 2008
Location: United States
Online Status: Offline
Posts: 5
Quote cmainard Replybullet Topic: Rounding to "Nearest...."
     Posted: 23 Jun 2011 at 9:00am
I am building a trading report that returns for me the amount of shares needed to sell to meet a certain cash amount.
 
What I would like to do, is take the number of shares I have calculated to sell, and round them to the nearest:
 
If (heldshares) is between 1 and 10 then round to nearest 1
If (heldshares) is between 11 and 50 then round to nearest 5
If (heldshares) is between 51 and 100 then round to nearest 10
If (heldshares) is between 101 and 500 then round to nearest 25
If (heldshares) is between 501 and 750 then round to nearest 50
 
and so on... not sure why this is stumping me...
 
Thank you for any assistance!!
thank you for helping
IP IP Logged
cmainard
Newbie
Newbie
Avatar

Joined: 22 Jul 2008
Location: United States
Online Status: Offline
Posts: 5
Quote cmainard Replybullet Posted: 23 Jun 2011 at 9:08am

AND.... answered my own question!!

 
mround  :-)
thank you for helping
IP IP Logged
kostya1122
Senior Member
Senior Member
Avatar

Joined: 13 Jun 2011
Online Status: Offline
Posts: 475
Quote kostya1122 Replybullet Posted: 23 Jun 2011 at 9:10am
if (heldshares) in 1 to 10 then  round((heldshares),1) else
If (heldshares) in 11 to 50 then round((heldshares),5) else....
IP IP Logged
cmainard
Newbie
Newbie
Avatar

Joined: 22 Jul 2008
Location: United States
Online Status: Offline
Posts: 5
Quote cmainard Replybullet Posted: 23 Jun 2011 at 9:54am

thanks!! Had to keep the mround (versus the round) but the 

in 1 to 10
 
part was crucial... otherwise results not as desired.
thank you for helping
IP IP Logged
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

HOME | FREE EBOOK | PROGRAMMING GUIDE | PURCHASE | REVIEWS | CONTACT ME | FAQ | LINKS | PRIVACY | CLICK PLAYS | BAEZL

© 2004-2026 Brian Bischof. All Rights Reserved.