Exactly. My first email asked how to round to the nearest 50, and I used Bruce's formula. But my second email said that the client had changed his mind and told me that he wanted it to always round UP. So yeah, first email 510 would've rounded down to 500; second email it would've rounded up to 550
Karen -----Original Message----- From: [email protected] To: [email protected] Sent: Tue, Jan 5, 2021 12:00 pm Subject: RE: Re[2]: [RBASE-L] - Rounding up/down - one more piece of info #yiv8347024776 #yiv8347024776 -- _filtered {} _filtered {} _filtered {} _filtered {} _filtered {}#yiv8347024776 #yiv8347024776 p.yiv8347024776MsoNormal, #yiv8347024776 li.yiv8347024776MsoNormal, #yiv8347024776 div.yiv8347024776MsoNormal {margin:0in;margin-bottom:.0001pt;font-size:12.0pt;font-family:New;}#yiv8347024776 a:link, #yiv8347024776 span.yiv8347024776MsoHyperlink {color:blue;text-decoration:underline;}#yiv8347024776 a:visited, #yiv8347024776 span.yiv8347024776MsoHyperlinkFollowed {color:purple;text-decoration:underline;}#yiv8347024776 p {margin-right:0in;margin-left:0in;font-size:12.0pt;font-family:New;}#yiv8347024776 p.yiv8347024776quote, #yiv8347024776 li.yiv8347024776quote, #yiv8347024776 div.yiv8347024776quote {margin-right:0in;margin-left:0in;font-size:12.0pt;font-family:New;}#yiv8347024776 p.yiv8347024776quote1, #yiv8347024776 li.yiv8347024776quote1, #yiv8347024776 div.yiv8347024776quote1 {margin-right:0in;margin-left:0in;font-size:12.0pt;font-family:New;}#yiv8347024776 p.yiv8347024776msonormal, #yiv8347024776 li.yiv8347024776msonormal, #yiv8347024776 div.yiv8347024776msonormal {margin-right:0in;margin-left:0in;font-size:12.0pt;font-family:New;}#yiv8347024776 p.yiv8347024776msonormal1, #yiv8347024776 li.yiv8347024776msonormal1, #yiv8347024776 div.yiv8347024776msonormal1 {margin-right:0in;margin-left:0in;font-size:12.0pt;font-family:New;}#yiv8347024776 p.yiv8347024776quote2, #yiv8347024776 li.yiv8347024776quote2, #yiv8347024776 div.yiv8347024776quote2 {margin-right:0in;margin-left:0in;font-size:12.0pt;font-family:New;}#yiv8347024776 p.yiv8347024776quote11, #yiv8347024776 li.yiv8347024776quote11, #yiv8347024776 div.yiv8347024776quote11 {margin-right:0in;margin-left:0in;font-size:12.0pt;font-family:New;}#yiv8347024776 span.yiv8347024776msohyperlink {}#yiv8347024776 span.yiv8347024776msohyperlinkfollowed {}#yiv8347024776 span.yiv8347024776msohyperlink1 {}#yiv8347024776 span.yiv8347024776msohyperlinkfollowed1 {}#yiv8347024776 span.yiv8347024776emailstyle201 {}#yiv8347024776 span.yiv8347024776emailstyle30 {}#yiv8347024776 p.yiv8347024776msonormal2, #yiv8347024776 li.yiv8347024776msonormal2, #yiv8347024776 div.yiv8347024776msonormal2 {margin:0in;margin-bottom:.0001pt;font-size:12.0pt;font-family:New;}#yiv8347024776 span.yiv8347024776msohyperlink2 {color:blue;text-decoration:underline;}#yiv8347024776 span.yiv8347024776msohyperlinkfollowed2 {color:purple;text-decoration:underline;}#yiv8347024776 p.yiv8347024776quote3, #yiv8347024776 li.yiv8347024776quote3, #yiv8347024776 div.yiv8347024776quote3 {margin-right:0in;margin-left:0in;font-size:12.0pt;font-family:New;}#yiv8347024776 p.yiv8347024776quote12, #yiv8347024776 li.yiv8347024776quote12, #yiv8347024776 div.yiv8347024776quote12 {margin-right:0in;margin-left:0in;font-size:12.0pt;font-family:New;}#yiv8347024776 p.yiv8347024776msonormal3, #yiv8347024776 li.yiv8347024776msonormal3, #yiv8347024776 div.yiv8347024776msonormal3 {margin-right:0in;margin-left:0in;font-size:12.0pt;font-family:New;}#yiv8347024776 p.yiv8347024776msonormal11, #yiv8347024776 li.yiv8347024776msonormal11, #yiv8347024776 div.yiv8347024776msonormal11 {margin:0in;margin-bottom:.0001pt;font-size:12.0pt;font-family:New;}#yiv8347024776 span.yiv8347024776msohyperlink11 {color:blue;text-decoration:underline;}#yiv8347024776 span.yiv8347024776msohyperlinkfollowed11 {color:purple;text-decoration:underline;}#yiv8347024776 p.yiv8347024776quote21, #yiv8347024776 li.yiv8347024776quote21, #yiv8347024776 div.yiv8347024776quote21 {margin-right:0in;margin-left:0in;font-size:12.0pt;font-family:New;}#yiv8347024776 p.yiv8347024776quote111, #yiv8347024776 li.yiv8347024776quote111, #yiv8347024776 div.yiv8347024776quote111 {margin-right:12.0pt;margin-left:12.0pt;font-size:12.0pt;font-family:New;}#yiv8347024776 span.yiv8347024776emailstyle2011 {color:#1F497D;}#yiv8347024776 span.yiv8347024776emailstyle301 {color:#1F497D;}#yiv8347024776 span.yiv8347024776EmailStyle43 {color:#1F497D;}#yiv8347024776 span.yiv8347024776SpellE {}#yiv8347024776 .yiv8347024776MsoChpDefault {} _filtered {}#yiv8347024776 div.yiv8347024776WordSection1 {}#yiv8347024776 I am a little bit confused.In your last post you wrote: “But as I said, in this case it always has to round UP, so 510 would be 550, not 500.” But, in your original post you wrote: I need to round an integer to the nearest 50 (up or down) IOW: 520 would be 500570 would be 550580 would be 600 This is not always rounding up, right?My solution will round up OR down to the nearest 50 as requested in the original post. I think I must be missing something very obvious but, so far, it has been one of those day…L Javier, Javier Valencia, [email protected]: 913-829-0888C: 913-915-3137 From: 'Karen Tellef' via RBASE-L [mailto:[email protected]] Sent: Tuesday, January 05, 2021 8:15 AM To: [email protected] Subject: Re: Re[2]: [RBASE-L] - Rounding up/down - one more piece of info Yes, I kept your formula too, altho I'm unsure of the benefit of it over the ROUND function which seems to work. But as I said, in this case it always has to round UP, so 510 would be 550, not 500. If you have an alternative to RNDUP function, I'd like to make note of that one too! Karen -----Original Message----- From: [email protected] To: [email protected] Sent: Tue, Jan 5, 2021 2:16 am Subject: RE: Re[2]: [RBASE-L] - Rounding up/down - one more piece of infoI believe my solution rounds of correctly, 510 becomes 500, 530 becomes 550, 570 becomes 550, 580 becomes 600 and so on and it should work on integers. Javier, Javier Valencia, [email protected]: 913-829-0888C: 913-915-3137 From: 'Karen Tellef' via RBASE-L [mailto:[email protected]] Sent: Monday, January 04, 2021 5:18 PM To: [email protected] Subject: Re: Re[2]: [RBASE-L] - Rounding up/down - one more piece of info After I incorporated Bruce's simple formula to do the rounding, then he tells me that it needs to always round up. So I looked at the RNDUP function and brought in Bruce's formula and got the following. The only issue is that RNDUP does not work on integer values, so I added a Double column to my temp table and loaded the numbers there. So using the formula:510 becomes 550580 becomes 600601 becomes 650 UPDATE tmpPlan SET AmtReleaseSum = ((RNDUP(tmpDouble / 50 , 0 )) * 50) Karen -----Original Message----- From: [email protected] To: [email protected] Sent: Mon, Jan 4, 2021 5:04 pm Subject: RE: Re[2]: [RBASE-L] - Rounding up/down - one more piece of infoI came up with this: Makes sure the types come out correct regardless on whether the input value is real or integer. SET VAR vIn INTEGER = 524SET VAR vOut INTEGER = (INT((ROUND((FLOAT(.vIn) / 50.0),0)) * 50)) Rounds to 500 525 rounds to 550 and so on… Best regards, Javier Valencia, PE14315 S. Twilight Ln.Olathe, KS 66062Cell: 913-915-3137 From: 'Karen Tellef' via RBASE-L [mailto:[email protected]] Sent: Monday, January 04, 2021 3:42 PM To: [email protected] Subject: Re: Re[2]: [RBASE-L] - Rounding up/down - one more piece of info Are you kidding me??? It's that freaking simple? Works like a charm! I looked at the "round" function but just couldn't figure out how to make that work! Damn I owe you one, kid Karen -----Original Message----- From: Bruce Chitiea <[email protected]> To: [email protected] <[email protected]> Sent: Mon, Jan 4, 2021 3:30 pm Subject: Re[2]: [RBASE-L] - Rounding up/down - one more piece of infoUPDATE table SET column = ( (ROUND(column/50,0)) * 50 ) Breaks at ( 24 | 25 ), ( 74 | 75 ) ------ Original Message ------From: "'Karen Tellef' via RBASE-L" <[email protected]>To: "[email protected]" <[email protected]>Sent: 1/4/2021 11:34:49 AMSubject: Re: [RBASE-L] - Rounding up/down - one more piece of info I won't be working with variables, this will be rounding up/down a column in a table Karen -----Original Message----- From: 'Karen Tellef' via RBASE-L <[email protected]> To: [email protected] <[email protected]> Sent: Mon, Jan 4, 2021 1:33 pm Subject: [RBASE-L] - Rounding up/downOkay, which of you geniuses out there have a formula to do this for me?? I need to round an integer to the nearest 50 (up or down) IOW: 520 would be 500570 would be 550580 would be 600 Someone have a nifty formula to do that, or do I have to do 3 calculations: how far is each number from 500, how far from 550, how far from 600, and then take whichever is smaller? Karen -- For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php --- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/rbase-l/1654091038.1383109.1609788794870%40mail.yahoo.com.-- For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php --- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/rbase-l/1839463282.854096.1609788889964%40mail.yahoo.com. -- For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php --- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/rbase-l/em3e1c5ea8-1640-4a00-bf34-dedbd51adc0b%40pathfinder.-- For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php --- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/rbase-l/118632094.5413336.1609796536585%40mail.yahoo.com.-- For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php --- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/rbase-l/!%26!AAAAAAAAAAAYAAAAAAAAAO1ueGVb5zRMiwo7hebUe7jCgAAAEAAAAE8iYPsm4M9Bg3Vlcc7vwyEBAAAAAA%3D%3D%40vtgonline.com.-- For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php --- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/rbase-l/456942744.5457426.1609802251202%40mail.yahoo.com.-- For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php --- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/rbase-l/!%26!AAAAAAAAAAAYAAAAAAAAAO1ueGVb5zRMiwo7hebUe7jCgAAAEAAAAD/IXeIYZvhKrI4Xwh4mnjwBAAAAAA%3D%3D%40vtgonline.com.-- For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php --- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/rbase-l/2142119419.544983.1609856077931%40mail.yahoo.com.-- For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php --- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/rbase-l/!%26!AAAAAAAAAAAYAAAAAAAAAO1ueGVb5zRMiwo7hebUe7jCgAAAEAAAAGvz%2BcXEnRJPjRiX%2B3T1/4YBAAAAAA%3D%3D%40vtgonline.com. -- For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php --- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/rbase-l/1962700721.778311.1609870272419%40mail.yahoo.com.
