Yes, Bruce, apologies. The "he" I referenced was indeed a "pesky client", not
you!!!
Karen
-----Original Message-----
From: Bruce Chitiea <[email protected]>
To: [email protected] <[email protected]>
Sent: Mon, Jan 4, 2021 5:24 pm
Subject: Re[4]: [RBASE-L] - Rounding up/down - one more piece of info
#yiv1618282826 #yiv1618282826 --blockquote.yiv1618282826cite
{margin-left:5px;margin-right:0px;padding-left:10px;padding-right:0px;border-left:1px
solid #cccccc;}#yiv1618282826 blockquote.yiv1618282826cite2
{margin-left:5px;margin-right:0px;padding-left:10px;padding-right:0px;border-left:1px
solid #cccccc;margin-top:3px;padding-top:0px;}#yiv1618282826 a img
{border:0px;}#yiv1618282826 , #yiv1618282826 , #yiv1618282826 , #yiv1618282826
{list-style-position:inside;}#yiv1618282826 body {font-family:Segoe
UI;font-size:12pt;}#yiv1618282826 .yiv1618282826quote
{margin-left:1em;margin-right:1em;border-left:5px #ebebeb
solid;padding-left:0.3em;}#yiv1618282826 "He" as in "pesky client", not that
genius A.E. feller. Have to watch out for our pronouns, these days.
I think Javier has the right approach to generalizing to manage INTEGER,
DOUBLE, REAL ...
Bruce
------ Original Message ------From: "'Karen Tellef' via RBASE-L"
<[email protected]>To: "[email protected]"
<[email protected]>Sent: 1/4/2021 3:17:31 PMSubject: 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 info
#yiv1618282826 --#yiv1618282826xf08a78fe54324c3 filtered, #yiv1618282826
#yiv1618282826xf08a78fe54324c3 filtered, #yiv1618282826
#yiv1618282826xf08a78fe54324c3 span.yiv1618282826SpellE, #yiv1618282826
#yiv1618282826xf08a78fe54324c3 .yiv1618282826MsoChpDefault, #yiv1618282826
#yiv1618282826xf08a78fe54324c3 div.yiv1618282826WordSection1{}#yiv1618282826
#yiv1618282826xf08a78fe54324c3 p.yiv1618282826MsoNormal, #yiv1618282826
#yiv1618282826xf08a78fe54324c3 li.yiv1618282826MsoNormal, #yiv1618282826
#yiv1618282826xf08a78fe54324c3 div.yiv1618282826MsoNormal{margin:0in 0in
0.0001pt;font-size:12pt;font-family:New;}#yiv1618282826
#yiv1618282826xf08a78fe54324c3 a:link, #yiv1618282826
#yiv1618282826xf08a78fe54324c3
span.yiv1618282826MsoHyperlink{color:blue;text-decoration:underline;}#yiv1618282826
#yiv1618282826xf08a78fe54324c3 a:visited, #yiv1618282826
#yiv1618282826xf08a78fe54324c3
span.yiv1618282826MsoHyperlinkFollowed{color:purple;text-decoration:underline;}#yiv1618282826
#yiv1618282826xf08a78fe54324c3 p, #yiv1618282826
#yiv1618282826xf08a78fe54324c3 p.yiv1618282826quote, #yiv1618282826
#yiv1618282826xf08a78fe54324c3 li.yiv1618282826quote, #yiv1618282826
#yiv1618282826xf08a78fe54324c3
div.yiv1618282826quote{margin-right:0in;margin-left:0in;font-size:12pt;font-family:New;}#yiv1618282826
#yiv1618282826xf08a78fe54324c3 p.yiv1618282826quote1, #yiv1618282826
#yiv1618282826xf08a78fe54324c3 li.yiv1618282826quote1, #yiv1618282826
#yiv1618282826xf08a78fe54324c3
div.yiv1618282826quote1{margin-right:12pt;margin-left:12pt;border:none;padding:0in;font-size:12pt;font-family:New;}#yiv1618282826
#yiv1618282826xf08a78fe54324c3 span.yiv1618282826EmailStyle20{color:rgb(31,
73, 125);}#yiv1618282826 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.
--
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/em2d9051fe-b586-4f0b-820d-98d32b8b054e%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/1706172846.545207.1609856122339%40mail.yahoo.com.
