"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 PM
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/em2d9051fe-b586-4f0b-820d-98d32b8b054e%40pathfinder.
