Edit codes for numeric data
You use numeric data edit codes to format fields containing numeric information in reports.
The letters "nn" in the numeric data edit codes represents a number between 0 and 99. This number determines how many places to allow after the decimal point. The following numeric data edit codes are available:
| Edit Code | Format | Notes |
|---|---|---|
| E | Displays numbers in scientific notation. | Up to 17 significant digits, or up to 34 significant digits when editing extended floating point data, are shown even if the width of the column can accommodate more. Used as the default form for columns with data type FLOAT. |
| EZ | Displays numbers in scientific notation with zero values in the column suppressed. | Up to 17 significant digits, or up to 34 significant digits when editing extended floating point data, are shown even if the width of the column can accommodate more. |
| Dnn | Displays numbers in decimal notation formatted with a negative sign, thousands separator, and currency symbol. | The value "nn" is a number (0 to 99) that represents how many places to allow for the decimal point. Numbers with more places after the decimal are rounded and numbers with fewer places are padded. |
| DZnn | Displays numbers in decimal notation formatted with a negative sign, thousands separator, currency symbol and any zero values in the column suppressed. | The value "nn" is a number (0 to 99) that represents how many places to allow for the decimal point. Numbers with more places after the decimal are rounded and numbers with fewer places are padded. |
| DCnn | Displays numbers in decimal notation formatted with a negative sign, thousands separator, and a user-defined currency symbol. | The value "nn" is a number (0 to 99) that represents how many places to allow for the decimal point. Numbers with more places after the decimal are rounded and numbers with fewer places are padded. The currency symbol that will be used instead of the standard currency symbol is defined using the global variable DSQDC_CURRENCY. |
| DZCnn | Displays numbers in decimal notation formatted with a negative sign, thousands separator, a user-defined currency symbol and any zero values in the column suppressed. | The value "nn" is a number (0 to 99) that represents how many places to allow for the decimal point. Numbers with more places after the decimal are rounded and numbers with fewer places are padded. The currency symbol that will be used instead of the standard currency symbol is defined using the global variable DSQDC_CURRENCY. If both edit code options "Z" and "C" are used, "C" must follow "Z". |
| Inn | Displays numbers in decimal notation formatted with leading zeros displayed and a negative sign. | The value "nn" is a number (0 to 99) that represents how many places to allow for the decimal point. Numbers with more places after the decimal are rounded and numbers with fewer places are padded. |
| IZnn | Displays numbers in decimal notation formatted with leading zeros displayed, a negative sign and any zero values in the column suppressed. | The value "nn" is a number (0 to 99) that represents how many places to allow for the decimal point. Numbers with more places after the decimal are rounded and numbers with fewer places are padded. |
| Jnn | Displays numbers in decimal notation formatted with leading zeros displayed. | The value "nn" is a number (0 to 99) that represents how many places to allow for the decimal point. Numbers with more places after the decimal are rounded and numbers with fewer places are padded. |
| JZnn | Displays numbers in decimal notation formatted with leading zeros displayed and any zero values in the column suppressed. | The value "nn" is a number (0 to 99) that represents how many places to allow for the decimal point. Numbers with more places after the decimal are rounded and numbers with fewer places are padded. |
| Knn | Displays numbers in decimal notation formatted with a negative sign and a thousands separator. | The value "nn" is a number (0 to 99) that represents how many places to allow for the decimal point. Numbers with more places after the decimal are rounded and numbers with fewer places are padded. |
| KZnn | Displays numbers in decimal notation formatted with a negative sign, a thousands separator and any zero values in the column suppressed. | The value "nn" is a number (0 to 99) that represents how many places to allow for the decimal point. Numbers with more places after the decimal are rounded and numbers with fewer places are padded. |
| Lnn | Displays numbers in decimal notation formatted with a negative sign. | The value "nn" is a number (0 to 99) that represents how many places to allow for the decimal point. Numbers with more places after the decimal are rounded and numbers with fewer places are padded. |
| LZnn | Displays numbers in decimal notation formatted with a negative sign and any zero values in the column suppressed. | The value "nn" is a number (0 to 99) that represents how many places to allow for the decimal point. Numbers with more places after the decimal are rounded and numbers with fewer places are padded. |
| Pnn | Displays numbers in decimal notation formatted with a negative sign, thousands separator, and a percent sign. | The value "nn" is a number (0 to 99) that represents how many places to allow for the decimal point. Numbers with more places after the decimal are rounded and numbers with fewer places are padded. |
| PZnn | Displays numbers in decimal notation formatted with a negative sign, thousands separator, a percent sign and any zero values in the column suppressed. | The value "nn" is a number (0 to 99) that represents how many places to allow for the decimal point. Numbers with more places after the decimal are rounded and numbers with fewer places are padded. |