I 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, PE [email protected] O: 913-829-0888 C: 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 550 580 becomes 600 601 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 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 = 524 SET 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, PE 14315 S. Twilight Ln. Olathe, KS 66062 Cell: 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 info UPDATE 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 AM Subject: 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/down Okay, 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 500 570 would be 550 580 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 <https://groups.google.com/d/msgid/rbase-l/1654091038.1383109.1609788794870%40mail.yahoo.com?utm_medium=email&utm_source=footer> . -- 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 <https://groups.google.com/d/msgid/rbase-l/1839463282.854096.1609788889964%40mail.yahoo.com?utm_medium=email&utm_source=footer> . -- 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 <https://groups.google.com/d/msgid/rbase-l/em3e1c5ea8-1640-4a00-bf34-dedbd51adc0b%40pathfinder?utm_medium=email&utm_source=footer> . -- 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 <https://groups.google.com/d/msgid/rbase-l/118632094.5413336.1609796536585%40mail.yahoo.com?utm_medium=email&utm_source=footer> . -- 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 <https://groups.google.com/d/msgid/rbase-l/!%26!AAAAAAAAAAAYAAAAAAAAAO1ueGVb5zRMiwo7hebUe7jCgAAAEAAAAE8iYPsm4M9Bg3Vlcc7vwyEBAAAAAA%3D%3D%40vtgonline.com?utm_medium=email&utm_source=footer> . -- 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 <https://groups.google.com/d/msgid/rbase-l/456942744.5457426.1609802251202%40mail.yahoo.com?utm_medium=email&utm_source=footer> . -- 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.
