Dan, That's pretty cool you got those results actually on your benchmark. I can only imagine why UniVerse would be like that? Maybe it has to look up some libraries with OCONV or do some stupid cross-checking. Either way that's actually a considerable difference if you were in a 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? > > X = 2596 * 8.333 ;* [X will contain 21632.468] > ANS = INT((X * 100) + .5) / 100 > PRINT ANS > > > The (X * 100) changes X to 2163246.8 > The + .5 changes X to 2163247.3 > The INT() changes X to 2163247 > The / 100 changes X to 21632.47 > > The output will displays 21632.47 > > Using a FOR NEXT loop, I run INT((21632.468 * 100) + .5) / 100 and > the OCONV(21632.468,'MR20') versions one million times and got .84 seconds > for > the INT version and 4.9 seconds for the OCONV version. > > I doubt that 4 seconds would make a difference to most programs but every > little > helps. > > I also run the OCONV(ICONV(21632.468,'MD2'),'MD2') version and it took 5.1 > seconds. > > My point: There is more than one way to skin a cat! > > Don Robinson > > > > > > > ________________________________ > From: Chris Austin <cjausti...@hotmail.com> > To: u2-users@listserver.u2ug.org > Sent: 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-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) ? > > > > > > -----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 8:59 AM > > To: U2 Users List > > 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 Support 1 (Finance Systems) | Travis > > 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 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? > > > > Hi > > > > I've always used 'R2' > > > > e.g. ANS = N1 * N2 'R2' > > > > No scaling, just rounding > > > > Regards > > > > John Woollam | Group Function Support 1 (Finance Systems) | Travis > > Perkins PLC | 01604 682751 > > -----Original Message----- > > From: u2-users-boun...@listserver.u2ug.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.468 > > > > How would you round that in UniVerse to 21,632.47? > > > > Thanks! > > > > _______________________________________________ > > U2-Users mailing list > > U2-Users@listserver.u2ug.org > > http://listserver.u2ug.org/mailman/listinfo/u2-users > > > > <html> > > <head> > > <meta http-equiv="Content-type" content="text/html; charset=UTF-8"> > > </head> > > <body> > > <P style="MARGIN-TOP: 0pt; MARGIN-BOTTOM: 0pt"><SPAN > > style="FONT-SIZE: 8.2pt; FONT-FAMILY: 'MS Sans Serif'">This e-mail and > > any > > attachments are confidential and intended solely for the use of the > > addressee > > only. If you have received this message in error, you must not copy, > > distribute > > or disclose the contents; please notify the sender immediately and > > delete > > the > > message. </SPAN></P> > > <P style="MARGIN-TOP: 0pt; MARGIN-BOTTOM: 0pt"><SPAN > > style="FONT-SIZE: 8.2pt; FONT-FAMILY: 'MS Sans Serif'">This message is > > attributed to the sender and may not necessarily reflect the view of > > Travis > > Perkins plc or its subsidiaries (Travis Perkins). Agreements binding > > Travis > > Perkins may not be concluded by means of e-mail communication. > > </SPAN></P> > > <P style="MARGIN-TOP: 0pt; MARGIN-BOTTOM: 0pt"><SPAN > > style="FONT-SIZE: 8.2pt; FONT-FAMILY: 'MS Sans Serif'">E-mail > > transmissions > > are > > not secure and Travis Perkins accepts no responsibility for changes made > > to > > this > > message after it was sent. Whilst steps have been taken to ensure that > > this > > message is virus free, Travis Perkins accepts no liability for infection > > and > > > > recommends that you scan this e-mail and any attachments. </SPAN></P> > > <P style="MARGIN-TOP: 0pt; MARGIN-BOTTOM: 0pt"><SPAN > > style="FONT-SIZE: 8.2pt; FONT-FAMILY: 'MS Sans Serif'">Part of Travis > > Perkins > > plc. Registered Office: Lodge Way House, Lodge Way, Harlestone Road, > > Northampton, NN5 7UG. </SPAN></P> > > </BODY> > > </HTML> > > > > _______________________________________________ > > U2-Users mailing list > > U2-Users@listserver.u2ug.org > > http://listserver.u2ug.org/mailman/listinfo/u2-users > > > > _______________________________________________ > > U2-Users mailing list > > U2-Users@listserver.u2ug.org > > http://listserver.u2ug.org/mailman/listinfo/u2-users > > > > <html> > > <head> > > <meta http-equiv="Content-type" content="text/html; charset=UTF-8"> > > </head> > > <body> > > <P style="MARGIN-TOP: 0pt; MARGIN-BOTTOM: 0pt"><SPAN > > style="FONT-SIZE: 8.2pt; FONT-FAMILY: 'MS Sans Serif'">This e-mail and any > > attachments are confidential and intended solely for the use of the > > addressee > > only. If you have received this message in error, you must not copy, > > distribute > > or disclose the contents; please notify the sender immediately and delete > > the > > message. </SPAN></P> > > <P style="MARGIN-TOP: 0pt; MARGIN-BOTTOM: 0pt"><SPAN > > style="FONT-SIZE: 8.2pt; FONT-FAMILY: 'MS Sans Serif'">This message is > > attributed to the sender and may not necessarily reflect the view of Travis > > Perkins plc or its subsidiaries (Travis Perkins). Agreements binding Travis > > Perkins may not be concluded by means of e-mail communication. </SPAN></P> > > <P style="MARGIN-TOP: 0pt; MARGIN-BOTTOM: 0pt"><SPAN > > style="FONT-SIZE: 8.2pt; FONT-FAMILY: 'MS Sans Serif'">E-mail transmissions > > are > > not secure and Travis Perkins accepts no responsibility for changes made to > > this > > message after it was sent. Whilst steps have been taken to ensure that this > > message is virus free, Travis Perkins accepts no liability for infection and > > > > recommends that you scan this e-mail and any attachments. </SPAN></P> > > <P style="MARGIN-TOP: 0pt; MARGIN-BOTTOM: 0pt"><SPAN > > style="FONT-SIZE: 8.2pt; FONT-FAMILY: 'MS Sans Serif'">Part of Travis > > Perkins > > plc. Registered Office: Lodge Way House, Lodge Way, Harlestone Road, > > Northampton, NN5 7UG. </SPAN></P> > > </BODY> > > </HTML> > > > > _______________________________________________ > > U2-Users mailing list > > U2-Users@listserver.u2ug.org > > http://listserver.u2ug.org/mailman/listinfo/u2-users > > > > _______________________________________________ > > U2-Users mailing list > > U2-Users@listserver.u2ug.org > > http://listserver.u2ug.org/mailman/listinfo/u2-users > > _______________________________________________ > U2-Users mailing list > U2-Users@listserver.u2ug.org > http://listserver.u2ug.org/mailman/listinfo/u2-users > _______________________________________________ > U2-Users mailing list > U2-Users@listserver.u2ug.org > http://listserver.u2ug.org/mailman/listinfo/u2-users _______________________________________________ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
