...@listserver.u2ug.org] On Behalf Of Chris Austin
Sent: 13 October 2010 22:22
To: u2-users@listserver.u2ug.org
Subject: [U2] how to round to 2 decimals?
I'm trying to figure out how to round to 2 decimal places with a
floating point in UniVerse
For example 2596 x 8.333 = 21,632.468
How would you round
Does UniVerse not support the DROUND() function?
-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of John Woollam
Sent: Thursday, October 14, 2010 1:02 AM
To: U2 Users List
Subject: Re: [U2] how to round to 2 decimals
| 01604 682751
-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Larry Hiscock
Sent: 14 October 2010 16:49
To: 'U2 Users List'
Subject: Re: [U2] how to round to 2 decimals?
Does UniVerse not support the DROUND() function
| 01604 682751
-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Larry Hiscock
Sent: 14 October 2010 16:49
To: 'U2 Users List'
Subject: Re: [U2] how to round to 2 decimals?
Does UniVerse not support the DROUND
What's the diff between
OCONV(X,'MR20') and DROUND(X,2) ??
where X = N1 * N2
From: lar...@wcs-corp.com
To: u2-users@listserver.u2ug.org
Date: Thu, 14 Oct 2010 09:25:23 -0700
Subject: Re: [U2] how to round to 2 decimals?
What's so difficult about ANS = DROUND(N1 * N2, 2
Subject: Re: [U2] how to round to 2 decimals?
Hi
Never heard of the DROUND() function in Universe.
Anyway, why would I want to use a function syntax when I can do
ANS = N1 * N2 'R2' and it is the answer that gets rounded?
Easy to write.
Easy to read...
John Woollam | Group Function
-users@listserver.u2ug.org
Subject: Re: [U2] how to round to 2 decimals?
Are you sure DROUND() is a UniVerse function?
When I do the following code:
X = 2596 * 8.333
*
PRINT DROUND(X,2)
I get the following error:
Array 'DROUND' never dimensioned.
From: lar...@wcs-corp.com
To: u2-users
:35 AM
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] how to round to 2 decimals?
Are you sure DROUND() is a UniVerse function?
When I do the following code:
X = 2596 * 8.333
*
PRINT DROUND(X,2)
I get the following error:
Array 'DROUND' never dimensioned.
From: lar...@wcs-corp.com
To: u2
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Chris Austin
Sent: Thursday, October 14, 2010 9:35 AM
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] how to round to 2 decimals?
Are you sure DROUND() is a UniVerse function?
When I do the following code:
X = 2596 * 8.333
.
And it works in all flavors
George
-Original Message-
From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-
boun...@listserver.u2ug.org] On Behalf Of Larry Hiscock
Sent: Thursday, October 14, 2010 12:25 PM
To: 'U2 Users List'
Subject: Re: [U2] how to round to 2 decimals?
What's so
Thanks George,
I know this will be helpful with scaling, I know the need will arise for this
in the future.
-Chris
From: ggal...@wyanokegroup.com
To: u2-users@listserver.u2ug.org
Date: Thu, 14 Oct 2010 12:23:50 -0500
Subject: Re: [U2] how to round to 2 decimals?
I always used int
: [U2] how to round to 2 decimals?
Are you sure DROUND() is a UniVerse function?
When I do the following code:
X = 2596 * 8.333
*
PRINT DROUND(X,2)
I get the following error:
Array 'DROUND' never dimensioned.
From: lar...@wcs-corp.com
To: u2-users@listserver.u2ug.org
Date: Thu, 14 Oct
with 5,000+
records lets says.
That would shave off 5 1/2 minutes of processing time!
-Chris
Date: Thu, 14 Oct 2010 11:00:08 -0700
From: donr_w...@yahoo.com
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] how to round to 2 decimals?
How about this?
X = 2596 * 8.333 ;* [X will contain
: Thu, October 14, 2010 12:34:36 PM
Subject: Re: [U2] how to round to 2 decimals?
Are you sure DROUND() is a UniVerse function?
When I do the following code:
X = 2596 * 8.333
*
PRINT DROUND(X,2)
I get the following error:
Array 'DROUND' never dimensioned.
From: lar...@wcs
, October 14, 2010 2:05 PM
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] how to round to 2 decimals?
oops.. I should have read your post closer.
' one million times' - so yeah that wouldn't make a huge difference but
it's still good to know!
-Chris
Date: Thu, 14 Oct 2010 11
:-)
Yep, no one would notice a half cent!!
Don Robinson
From: George Gallen ggal...@wyanokegroup.com
To: U2 Users List u2-users@listserver.u2ug.org
Sent: Thu, October 14, 2010 2:07:00 PM
Subject: Re: [U2] how to round to 2 decimals?
so, when the bank rounds
I'm trying to figure out how to round to 2 decimal places with a floating point
in UniVerse
For example 2596 x 8.333 = 21,632.468
How would you round that in UniVerse to 21,632.47?
Thanks!
___
U2-Users
X=2596 x 8.333
OCONV(X,MR2)
From: cjausti...@hotmail.com
To: u2-users@listserver.u2ug.org
Date: Wed, 13 Oct 2010 16:22:04 -0500
Subject: [U2] how to round to 2 decimals?
I'm trying to figure out how to round to 2 decimal places with a floating
point in UniVerse
For example 2596 x
OCONV(X,MD2)
Robert F. Porter, MCSE, CCNA, ZCE
Lead Sr. Programmer / Analyst
Laboratory Information Services
Ochsner Health System
This transmission (including any attachments) may contain confidential
information, privileged material (including material protected by the
Subject: [U2] how to round to 2 decimals?
I'm trying to figure out how to round to 2 decimal places with a floating
point in UniVerse
For example 2596 x 8.333 = 21,632.468
How would you round that in UniVerse to 21,632.47?
Thanks
If the value already has the decimal point in it, MR2 or MD2 will scale the
value as well as round. If you want to leave the decimal place alone, use:
ROUNDED = OCONV(ORIGINAL.VALUE,'MR20')
Remember that MR2 or MD2 is the same as MR22/MD22, where the first number is
the number of decimals to
Date: Wed, 13 Oct 2010 15:37:29 -0600
From: precisonl...@gmail.com
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] how to round to 2 decimals?
If the value already has the decimal point in it, MR2 or MD2 will scale the
value as well as round. If you want to leave the decimal place alone
Hi,
Use OCONV(21632.468,'MR20')
Manu
-Message d'origine-
De : u2-users-boun...@listserver.u2ug.org [mailto:u2-users-
boun...@listserver.u2ug.org] De la part de Chris Austin
Envoyé : mercredi 13 octobre 2010 23:22
À : u2-users@listserver.u2ug.org
Objet : [U2] how to round to 2
23 matches
Mail list logo