Numbers are important SCADA attributes that informs the operator about the state of their equipment. You can use custom Number Format patterns to change the way numbers are displayed.
A custom Number Format consists of a pattern of characters:
| Character | Description |
|---|---|
| 0 | A placeholder for a digit. The digit is always shown. |
| # | A placeholder for a digit. Leading and trailing zeros are not shown. |
| . | A full stop is the placeholder for the decimal point. (For example 0.00). |
| , | A comma is the group separator for thousands. (For example #,##0). |
| E/e | Displays the number in scientific notation. The pattern before the 'E' or 'e' is used for the mantissa. The pattern after the 'E' or 'e' is used for the exponent. |
| + | Always display a sign character in the exponent. (For example 0.00e+00). |
| ; | The pattern separator. The pattern before the ';' is used for positive numbers. The pattern after the ';' is used for negative numbers. |
| ' | Used to include special characters in the prefix or suffix. |
Characters not listed in the above table are copied directly to the output.
You can use Number Format strings in these areas:
These examples show how number format patterns change the way numbers are displayed:
| Number | Pattern | Result | Comment |
|---|---|---|---|
| 12.59 | #.## | 12.59 | |
| 12.59 | #.# | 12.6 | Value is rounded up |
| 12.59 | # | 13 | |
| 12.0 | #.## | 12 | |
| 12.0 | #.00 | 12.00 | |
| 12.0 | $#.00 | $12.00 | The '$' prefix appears before the number. |
| 12.0 | #.00 litres | 12.00 litres | The ' litres' suffix appears after the number. |
| 50000 | # | 50000 | |
| 50000 | '#'# | #50000 | The quote character escapes the first '#'. |
| 50000 | #,### | 50,000 | The ',' comma character is used to group digits. In this case thousands. |
| 50000 | 0.00E0 | 5.00E5 | The 'E' character forces scientific notation. |
| 50000 | 0.0e+0 | 5.0e+5 | The '+' always displays the sign of the exponent. |
| 50000 | ##0.0e+00 | 50.000e+03 | An exponent format with more than 1 pattern character before the full stop rounds the exponent. In this case the exponent is rounded to a multiple of 3. |
| -50,000 | #,### | -50,000 | The default way of displaying negative numbers uses a minus sign '-'. |
| -50,000 | #,###;(#,###) | (50,000) | The second format pattern after the ';' is used for negative numbers. |
| 50,000 | +#,###;-#,### | +50,000 | To force the display of '+' or '-' use two format strings separated by a ';'. |
To learn how for format dates and times.
To learn about other Fernhill SCADA Concepts.
To learn how to format numbers in IEC 61131-3 code.
For the meaning of terms used in Fernhill SCADA.
