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 info
#yiv6235535891 #yiv6235535891 -- _filtered {} _filtered {} _filtered {}
_filtered {} _filtered {} _filtered {}#yiv6235535891 #yiv6235535891
p.yiv6235535891MsoNormal, #yiv6235535891 li.yiv6235535891MsoNormal,
#yiv6235535891 div.yiv6235535891MsoNormal
{margin:0in;margin-bottom:.0001pt;font-size:12.0pt;font-family:New;}#yiv6235535891
a:link, #yiv6235535891 span.yiv6235535891MsoHyperlink
{color:blue;text-decoration:underline;}#yiv6235535891 a:visited, #yiv6235535891
span.yiv6235535891MsoHyperlinkFollowed
{color:purple;text-decoration:underline;}#yiv6235535891 p
{margin-right:0in;margin-left:0in;font-size:12.0pt;font-family:New;}#yiv6235535891
p.yiv6235535891quote, #yiv6235535891 li.yiv6235535891quote, #yiv6235535891
div.yiv6235535891quote
{margin-right:0in;margin-left:0in;font-size:12.0pt;font-family:New;}#yiv6235535891
p.yiv6235535891quote1, #yiv6235535891 li.yiv6235535891quote1, #yiv6235535891
div.yiv6235535891quote1
{margin-right:0in;margin-left:0in;font-size:12.0pt;font-family:New;}#yiv6235535891
p.yiv6235535891msonormal, #yiv6235535891 li.yiv6235535891msonormal,
#yiv6235535891 div.yiv6235535891msonormal
{margin-right:0in;margin-left:0in;font-size:12.0pt;font-family:New;}#yiv6235535891
span.yiv6235535891msohyperlink {}#yiv6235535891
span.yiv6235535891msohyperlinkfollowed {}#yiv6235535891
span.yiv6235535891emailstyle20 {}#yiv6235535891 p.yiv6235535891msonormal1,
#yiv6235535891 li.yiv6235535891msonormal1, #yiv6235535891
div.yiv6235535891msonormal1
{margin:0in;margin-bottom:.0001pt;font-size:12.0pt;font-family:New;}#yiv6235535891
span.yiv6235535891msohyperlink1
{color:blue;text-decoration:underline;}#yiv6235535891
span.yiv6235535891msohyperlinkfollowed1
{color:purple;text-decoration:underline;}#yiv6235535891 p.yiv6235535891quote2,
#yiv6235535891 li.yiv6235535891quote2, #yiv6235535891 div.yiv6235535891quote2
{margin-right:0in;margin-left:0in;font-size:12.0pt;font-family:New;}#yiv6235535891
p.yiv6235535891quote11, #yiv6235535891 li.yiv6235535891quote11, #yiv6235535891
div.yiv6235535891quote11
{margin-right:12.0pt;margin-left:12.0pt;font-size:12.0pt;font-family:New;}#yiv6235535891
span.yiv6235535891emailstyle201 {color:#1F497D;}#yiv6235535891
span.yiv6235535891EmailStyle30 {color:#1F497D;}#yiv6235535891
span.yiv6235535891SpellE {}#yiv6235535891 .yiv6235535891MsoChpDefault {}
_filtered {}#yiv6235535891 div.yiv6235535891WordSection1 {}#yiv6235535891 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, [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.
