IKR? I now have a solution for every situation now!
Karen
-----Original Message-----
From: [email protected]
To: [email protected]
Sent: Wed, Jan 6, 2021 12:20 am
Subject: RE: Re[2]: [RBASE-L] - Rounding up/down - one more piece of info
#yiv0021280688 #yiv0021280688 -- _filtered {} _filtered {} _filtered {}
_filtered {} _filtered {}#yiv0021280688 #yiv0021280688
p.yiv0021280688MsoNormal, #yiv0021280688 li.yiv0021280688MsoNormal,
#yiv0021280688 div.yiv0021280688MsoNormal
{margin:0in;margin-bottom:.0001pt;font-size:12.0pt;font-family:New;}#yiv0021280688
a:link, #yiv0021280688 span.yiv0021280688MsoHyperlink
{color:blue;text-decoration:underline;}#yiv0021280688 a:visited, #yiv0021280688
span.yiv0021280688MsoHyperlinkFollowed
{color:purple;text-decoration:underline;}#yiv0021280688 p
{margin-right:0in;margin-left:0in;font-size:12.0pt;font-family:New;}#yiv0021280688
p.yiv0021280688quote, #yiv0021280688 li.yiv0021280688quote, #yiv0021280688
div.yiv0021280688quote
{margin-right:0in;margin-left:0in;font-size:12.0pt;font-family:New;}#yiv0021280688
p.yiv0021280688quote1, #yiv0021280688 li.yiv0021280688quote1, #yiv0021280688
div.yiv0021280688quote1
{margin-right:0in;margin-left:0in;font-size:12.0pt;font-family:New;}#yiv0021280688
p.yiv0021280688msonormal, #yiv0021280688 li.yiv0021280688msonormal,
#yiv0021280688 div.yiv0021280688msonormal
{margin-right:0in;margin-left:0in;font-size:12.0pt;font-family:New;}#yiv0021280688
p.yiv0021280688msonormal1, #yiv0021280688 li.yiv0021280688msonormal1,
#yiv0021280688 div.yiv0021280688msonormal1
{margin-right:0in;margin-left:0in;font-size:12.0pt;font-family:New;}#yiv0021280688
p.yiv0021280688quote2, #yiv0021280688 li.yiv0021280688quote2, #yiv0021280688
div.yiv0021280688quote2
{margin-right:0in;margin-left:0in;font-size:12.0pt;font-family:New;}#yiv0021280688
p.yiv0021280688quote11, #yiv0021280688 li.yiv0021280688quote11, #yiv0021280688
div.yiv0021280688quote11
{margin-right:0in;margin-left:0in;font-size:12.0pt;font-family:New;}#yiv0021280688
p.yiv0021280688msonormal2, #yiv0021280688 li.yiv0021280688msonormal2,
#yiv0021280688 div.yiv0021280688msonormal2
{margin-right:0in;margin-left:0in;font-size:12.0pt;font-family:New;}#yiv0021280688
p.yiv0021280688quote3, #yiv0021280688 li.yiv0021280688quote3, #yiv0021280688
div.yiv0021280688quote3
{margin-right:0in;margin-left:0in;font-size:12.0pt;font-family:New;}#yiv0021280688
p.yiv0021280688quote12, #yiv0021280688 li.yiv0021280688quote12, #yiv0021280688
div.yiv0021280688quote12
{margin-right:0in;margin-left:0in;font-size:12.0pt;font-family:New;}#yiv0021280688
p.yiv0021280688msonormal3, #yiv0021280688 li.yiv0021280688msonormal3,
#yiv0021280688 div.yiv0021280688msonormal3
{margin-right:0in;margin-left:0in;font-size:12.0pt;font-family:New;}#yiv0021280688
p.yiv0021280688msonormal11, #yiv0021280688 li.yiv0021280688msonormal11,
#yiv0021280688 div.yiv0021280688msonormal11
{margin-right:0in;margin-left:0in;font-size:12.0pt;font-family:New;}#yiv0021280688
p.yiv0021280688quote21, #yiv0021280688 li.yiv0021280688quote21, #yiv0021280688
div.yiv0021280688quote21
{margin-right:0in;margin-left:0in;font-size:12.0pt;font-family:New;}#yiv0021280688
p.yiv0021280688quote111, #yiv0021280688 li.yiv0021280688quote111,
#yiv0021280688 div.yiv0021280688quote111
{margin-right:0in;margin-left:0in;font-size:12.0pt;font-family:New;}#yiv0021280688
span.yiv0021280688msohyperlink {}#yiv0021280688
span.yiv0021280688msohyperlinkfollowed {}#yiv0021280688
span.yiv0021280688msohyperlink2 {}#yiv0021280688
span.yiv0021280688msohyperlinkfollowed2 {}#yiv0021280688
span.yiv0021280688msohyperlink11 {}#yiv0021280688
span.yiv0021280688msohyperlinkfollowed11 {}#yiv0021280688
span.yiv0021280688emailstyle2011 {}#yiv0021280688
span.yiv0021280688emailstyle301 {}#yiv0021280688 span.yiv0021280688emailstyle43
{}#yiv0021280688 p.yiv0021280688msonormal4, #yiv0021280688
li.yiv0021280688msonormal4, #yiv0021280688 div.yiv0021280688msonormal4
{margin:0in;margin-bottom:.0001pt;font-size:12.0pt;font-family:New;}#yiv0021280688
span.yiv0021280688msohyperlink1
{color:blue;text-decoration:underline;}#yiv0021280688
span.yiv0021280688msohyperlinkfollowed1
{color:purple;text-decoration:underline;}#yiv0021280688 p.yiv0021280688quote4,
#yiv0021280688 li.yiv0021280688quote4, #yiv0021280688 div.yiv0021280688quote4
{margin-right:0in;margin-left:0in;font-size:12.0pt;font-family:New;}#yiv0021280688
p.yiv0021280688quote13, #yiv0021280688 li.yiv0021280688quote13, #yiv0021280688
div.yiv0021280688quote13
{margin-right:0in;margin-left:0in;font-size:12.0pt;font-family:New;}#yiv0021280688
p.yiv0021280688msonormal5, #yiv0021280688 li.yiv0021280688msonormal5,
#yiv0021280688 div.yiv0021280688msonormal5
{margin-right:0in;margin-left:0in;font-size:12.0pt;font-family:New;}#yiv0021280688
p.yiv0021280688msonormal12, #yiv0021280688 li.yiv0021280688msonormal12,
#yiv0021280688 div.yiv0021280688msonormal12
{margin-right:0in;margin-left:0in;font-size:12.0pt;font-family:New;}#yiv0021280688
p.yiv0021280688quote22, #yiv0021280688 li.yiv0021280688quote22, #yiv0021280688
div.yiv0021280688quote22
{margin-right:0in;margin-left:0in;font-size:12.0pt;font-family:New;}#yiv0021280688
p.yiv0021280688quote112, #yiv0021280688 li.yiv0021280688quote112,
#yiv0021280688 div.yiv0021280688quote112
{margin-right:0in;margin-left:0in;font-size:12.0pt;font-family:New;}#yiv0021280688
p.yiv0021280688msonormal21, #yiv0021280688 li.yiv0021280688msonormal21,
#yiv0021280688 div.yiv0021280688msonormal21
{margin:0in;margin-bottom:.0001pt;font-size:12.0pt;font-family:New;}#yiv0021280688
span.yiv0021280688msohyperlink21
{color:blue;text-decoration:underline;}#yiv0021280688
span.yiv0021280688msohyperlinkfollowed21
{color:purple;text-decoration:underline;}#yiv0021280688 p.yiv0021280688quote31,
#yiv0021280688 li.yiv0021280688quote31, #yiv0021280688 div.yiv0021280688quote31
{margin-right:0in;margin-left:0in;font-size:12.0pt;font-family:New;}#yiv0021280688
p.yiv0021280688quote121, #yiv0021280688 li.yiv0021280688quote121,
#yiv0021280688 div.yiv0021280688quote121
{margin-right:0in;margin-left:0in;font-size:12.0pt;font-family:New;}#yiv0021280688
p.yiv0021280688msonormal31, #yiv0021280688 li.yiv0021280688msonormal31,
#yiv0021280688 div.yiv0021280688msonormal31
{margin-right:0in;margin-left:0in;font-size:12.0pt;font-family:New;}#yiv0021280688
p.yiv0021280688msonormal111, #yiv0021280688 li.yiv0021280688msonormal111,
#yiv0021280688 div.yiv0021280688msonormal111
{margin:0in;margin-bottom:.0001pt;font-size:12.0pt;font-family:New;}#yiv0021280688
span.yiv0021280688msohyperlink111
{color:blue;text-decoration:underline;}#yiv0021280688
span.yiv0021280688msohyperlinkfollowed111
{color:purple;text-decoration:underline;}#yiv0021280688
p.yiv0021280688quote211, #yiv0021280688 li.yiv0021280688quote211,
#yiv0021280688 div.yiv0021280688quote211
{margin-right:0in;margin-left:0in;font-size:12.0pt;font-family:New;}#yiv0021280688
p.yiv0021280688quote1111, #yiv0021280688 li.yiv0021280688quote1111,
#yiv0021280688 div.yiv0021280688quote1111
{margin-right:12.0pt;margin-left:12.0pt;font-size:12.0pt;font-family:New;}#yiv0021280688
span.yiv0021280688emailstyle20111 {color:#1F497D;}#yiv0021280688
span.yiv0021280688emailstyle3011 {color:#1F497D;}#yiv0021280688
span.yiv0021280688emailstyle431 {color:#1F497D;}#yiv0021280688
span.yiv0021280688EmailStyle63 {color:#1F497D;}#yiv0021280688
.yiv0021280688MsoChpDefault {} _filtered {}#yiv0021280688
div.yiv0021280688WordSection1 {}#yiv0021280688 Great. Now, if the your changes
his mind you already have the solution. J 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 12:11 PM
To: [email protected]
Subject: Re: Re[2]: [RBASE-L] - Rounding up/down - one more piece of info
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 infoI 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.--
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!AAAAAAAAAAAYAAAAAAAAAO1ueGVb5zRMiwo7hebUe7jCgAAAEAAAAN7R5TQyxs1OrExrslwPgB4BAAAAAA%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/633912862.5946901.1609942910743%40mail.yahoo.com.
