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 info #yiv9902223349 #yiv9902223349 -- _filtered {} _filtered {}#yiv9902223349 #yiv9902223349 p.yiv9902223349MsoNormal, #yiv9902223349 li.yiv9902223349MsoNormal, #yiv9902223349 div.yiv9902223349MsoNormal {margin:0in;margin-bottom:.0001pt;font-size:12.0pt;font-family:New;}#yiv9902223349 a:link, #yiv9902223349 span.yiv9902223349MsoHyperlink {color:blue;text-decoration:underline;}#yiv9902223349 a:visited, #yiv9902223349 span.yiv9902223349MsoHyperlinkFollowed {color:purple;text-decoration:underline;}#yiv9902223349 p {margin-right:0in;margin-left:0in;font-size:12.0pt;font-family:New;}#yiv9902223349 p.yiv9902223349quote, #yiv9902223349 li.yiv9902223349quote, #yiv9902223349 div.yiv9902223349quote {margin-right:0in;margin-left:0in;font-size:12.0pt;font-family:New;}#yiv9902223349 p.yiv9902223349quote1, #yiv9902223349 li.yiv9902223349quote1, #yiv9902223349 div.yiv9902223349quote1 {margin-right:12.0pt;margin-left:12.0pt;border:none;padding:0in;font-size:12.0pt;font-family:New;}#yiv9902223349 span.yiv9902223349EmailStyle20 {color:#1F497D;}#yiv9902223349 span.yiv9902223349SpellE {}#yiv9902223349 .yiv9902223349MsoChpDefault {} _filtered {}#yiv9902223349 div.yiv9902223349WordSection1 {}#yiv9902223349 I 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.
