:-)
Yep, no one would notice a half cent!!
Don Robinson
From: George Gallen
To: U2 Users List
Sent: Thu, October 14, 2010 2:07:00 PM
Subject: Re: [U2] how to round to 2 decimals?
so, when the bank rounds everyones bank balances down the cent, the system
in
> Sent: Thursday, 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
>
e is more than one way to skin a cat!
>
> Don Robinson
>
>
>
>
>
>
> ____
> From: Chris Austin
> To: u2-users@listserver.u2ug.org
> Sent: Thu, October 14, 2010 12:34:36 PM
> Subject: Re: [U2] how to round to 2 decimals?
>
&g
LOOP 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?
>
>
tserver.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) ?
>
>
> -Original Message-
> From: u2-users-boun...@listserver.u2ug.org
> [mailto:u2-users-boun..
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?
>
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
...@listserver.u2ug.org
> [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 functio
, 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
*
PRINT DROUND(X,2)
I get the following error:
"Array 'DROUND' never dimensione
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...
2010 09:25:23 -0700
> Subject: Re: [U2] how to round to 2 decimals?
>
> What's so difficult about ANS = DROUND(N1 * N2, 2) ?
>
>
> -Original Message-
> From: u2-users-boun...@listserver.u2ug.org
> [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of John W
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 d
vis
Perkins PLC | 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 UniVer
erkins PLC | 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 t
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
org
[mailto:u2-users-boun...@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.46
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
D2'),'MD2')
OCONV(X,'MR20')
you guys rock! :-)
-Chris
> 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
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 sho
r.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 that in UniVerse to 21,
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
solicitor-c
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 fl
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 maili
23 matches
Mail list logo
