:-) 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 everyones bank balances down the cent, the system would barely pause.....maybe noone would notice....hmmmmmmm. > -----Original Message----- > From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users- > boun...@listserver.u2ug.org] On Behalf Of Chris Austin > 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 > it's still good to know! > > -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 _______________________________________________ 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