Re: [U2] how to round to 2 decimals?
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 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 ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] XLr8Editor and Tools Updates
Hi Bill: We do offer trial licenses. Follow the installation instructions at www.u2logic.com/pdfs/XLr8Installation.pdf. Then send us you install id and we will send you a 30 day license. Regards, Doug www.u2logic.com -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Bill Brutzman Sent: Wednesday, October 13, 2010 3:59 PM To: U2 Users List Subject: Re: [U2] XLr8Editor and Tools Updates What... no try and buy? --Bill ___ 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
Re: [U2] XLr8Editor and Tools Updates
What... no try and buy? --Bill ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] how to round to 2 decimals?
Thanks so much! X = 2597 * 8.333 PRINT OCONV(X,"MR2") PRINT OCONV(X,"MD2") PRINT OCONV(ICONV(X,'MD2'),'MD2') PRINT OCONV(X,'MR20') yields the following: 216.41 216.41 21640.80 21640.80 so basically the 2 that worked are: OCONV(ICONV(X,'MD2'),'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 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 show and the second digit is the number of > decimals to scale. > > -K > ___ > 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
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, 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 show and the second digit is the number of decimals to scale. -K ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] how to round to 2 decimals?
ROUNDED.VALUE = ICONV(ORIGINAL.VALUE,'MD2') Will convert original to 2163247 -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Chris Austin Sent: Wednesday, October 13, 2010 2:22 PM 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 ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] how to round to 2 decimals?
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-client or other applicable privileges), or constitute non-public information. Any use of this information by anyone other than the intended recipient is prohibited. If you have received this transmission in error, please immediately reply to the sender and delete this information from your system. Use, dissemination, distribution, or reproduction of this transmission by unintended recipients is not authorized and may be unlawful. >>> Chris Austin 10/13/2010 4:22 PM >>> 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 ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] how to round to 2 decimals?
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 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 ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
[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
[U2] XLr8Editor and Tools Updates
[ad] XLr8Editor is still only $49.00 per year per workstation. Join the hundreds of users that are using the finest U2 Editor on the market. We have a tool that allow you to do UniBasic installations remotely. We have tool that allows you to create objects for use with our web developer tool. We have a tool that allows you to copy and paste from Unidata to Unidata, Universe to Universe, and Unidata to Universe. We have a tool that allows you to resize your account without any software being downloaded to your database. XLr8Editor runs on Universe version 9.6 or above or Unidata version 6.0 or above. We are SOX complaint. We maintain a before and after history for all changes through the editor. We have access to version control software like CVS, Subversion, Perforce, and GIT built into the Eclipse IDE which we use as our platform. We allow you to copy megabytes of data from U2 files system to file system that is 100% complaint structurally because we are using UniObjects technology. We put out releases for bug fixes and an enhancements many times a year so you never have to wait for years for fixes. Below is a small list of what has been enhanced or fix in the last few months. 1. Rewrote connection manager to speed up the process of editing code, compiling code, formatting code, and our copy and paste utility (50% improvement). 2. Only a single user is required now to edit, compile, and format code. 3. Added open source Quartz to our XLr8 Tools to keep those connections from timing out. 4. Added XLr8Monitor to allow you to close connections by account or all them. If you close them and try, for example, the XLr8Editor, the connection will be reopened. 5. Added open source log4j to capture all of the logging to a real file instead of going to the console. With this logging capability we can control the granularity of the logging process. 6. When you compile a program the XLr8Editor marks your code if you have any errors. Those markers use to go away when you closed the program and you still had those errors. Those markers will stay until your next compile which is hopefully clean and has no errors. 7. Updated the registration process for adding accounts and servers. This should make it easier to diagnose when you have either a bad password or account path issue. 8. Added a filter so you can filter out Dictionary files from the view. Of course this works only if you turn it on. 9. On Universe you now have the option to call another program to format code instead of AE. 10. Added the Save Password option to meet the PCI Security Standards to not save the password after you have closed eclipse. [/ad] Regards, Doug www.u2logic.com/tools.html BTW: You can download the tool and use the copy and paste utilities for free see www.u2logic.com/pdfs/XLr8Installation.pdf for complete installation instructions. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users