Razzak, Thank you for this timely tutorial on scientific notation. It also confirms that this is for REPORT formats. I had asked the question on the list if it worked in forms but the question email bounced back.
For now this will work great as I chase down another potential issue (when rounding, result must be even). Jan -----Original Message----- From: "A. Razzak Memon" <[email protected]> To: [email protected] (RBASE-L Mailing List) Date: Fri, 07 Nov 2014 10:11:36 -0500 Subject: [RBASE-L] - Tip of the Day: Using Scientific Notation for Display Format Friday, November 7, 2014 Tip of the Day: Using Scientific Notation for Display Format Product.: R:BASE eXtreme 9.5 (32/64) Build...: 9.5.4.30930 or higher www.rupdates.com [http://www.rupdates.com/] Section.: Report Designer Keywords: Display Format While in Report Designer, you may leave the default format of any underlying data type, or you may customize the display format of all data-aware controls as follows: Report Designer | Select Appropriate Control | Right-Click | Display Format For controls with numeric data types in R:BASE eXtreme 9.5 (64), such as, INTEGER, REAL, CURRENCY, DOUBLE, NUMERIC, and BIGNUM, notice the following available options: #,0;-#,0 #,0.00;-#,0.00 #,0.00;(#,0.00) $#,0.00;($#,0.00) $#,0.00;-$#,0.00 $#,0;-$#,0 $#,0;($#,0) 0 % 0.00 % You may overwrite the display format and further customize, if you wish. Did you know that you can customize the Display Format for Scientific Notation? Here's how ... Use the Display Format as follows: ##,E+00 Where ... ## should be for the significant number 00 is the number of digits to be displayed after the E. Note: To not show a '+', use "##,E-00". A sign will only be displayed if exponent is negative. If any of the strings "E+", "E-", "e+", or "e-" are contained in the Display Format string, the number is formatted using scientific notation. A group of up to four "0" characters can immediately follow the "E+", "E-", "e+", or "e-" to determine the minimum number of digits in the exponent. The "E+" and "e+" formats cause a plus sign to be output for positive exponents and a minus sign to be output for negative exponents. The "E-" and "e-" formats output a sign character only for negative exponents. Have fun! Very Best R:egards, Razzak. www.rbase.com [http://www.rbase.com/] www.facebook.com/rbase [http://www.facebook.com/rbase] -- 31 years of continuous innovation! 16 Years of R:BASE Technologies, Inc. making R:BASE what it is today! --
