Numeric Modifier Formats
As with Date/Time Modifiers, Numeric Modifier formats can control the way in which numbers are displayed. The table below shows the supported options along with an example of each. The examples are based on the number 12345.67890.
Several of the formats are based on the regional settings
of the current User’s machine.
Format | Example |
---|---|
Number | 12345.68 |
Number (set decimals) | 12345.7 (one decimal place) |
General | 12345.6789 |
Currency | $12345.68 |
Currency (set decimals) | $12345.678 (three decimal places) |
Fixed Point | 12345.68 |
Fixed Point (set decimals) | 12345.679 (three decimal places) |
Percent | 1,234,567.89% |
Percent (set decimals) | 1,234,567.890% (three decimal places) |
Scientific | 1.234568E+ 004 |
Hexadecimal | ABCD (from value 43981) |
Custom | Requires knowledge of the legal .NET numeric formats. An example: F3, which would return 12345.679 . |
After applying a Numeric format, the resulting value is
considered to be Text, so any Text operators can then be applied to the value.
Cherwell follows IEEE standards for rounding numerical values,
specifically the
round to nearest, ties to even rule.