FORMATDECIMAL
The FORMATDECIMAL function converts the input numerical value to it's specified decimal format.
Input/Output
Number of Connections: 1
| Input | Data Type | Description |
| Input1 | Integer,Double,Decimal | The numeric value to convert. |
| Output | Data Type | Description |
| Output1 | String | The decimal form. |
Property
| Name | Property Type | Description |
| Format | string |
Specifies the decimal pattern. Reserved pattern letters are listed below:
| Symbol | Description |
| 0 | digit (If no value found, set to zero) |
| # | digit (If no value found, not set) |
| . | digit delimiter |
| , | group delimiter |
| E | separates mantissa and exponent in scientific notation |
| ; | separates positive and negative sub patterns |
| - | default negative prefix |
| % | multiply by 100 and show as percentage |
| X | other arbitrary characters can be placed at the front or end of the decimal |
| ' | used to quote reserved pattern letters in the prefix or suffix; for example, "'#'#" formats 123 to "#123" |
|
Topic
- If the output is of type Decimal, the decimal scale is rounded using the ROUND_HALF_EVEN mode.
Example
| Property | Output |
| Input1 | 1234.567 | Format | # | 1235 |
| Property | Output |
| Input1 | 23 | Format | 0000 | 0023 |
| Property | Output |
| Input1 | 12345 | Format | #,### | 12,345 |