 |
Online Help System
|
 |
Back to Brilliant Database Web-Site |
Write to Support |
Help Index
Formatting Numbers
Basic Information
To learn more about how and where you can use formatting, see the Using Formatting section. Formatting Numbers
This format is used for formatting digits. Format string example: math ###-#0,00
- "-" - means a symbol used to separate groups;
- "," - means a symbol used to separate decimal part;
- Number of "#" means the number of digits in a group;
- Number of "0" means the number of digits after decimal. You can use "*" to view all digits after decimal.
- If you specify |NO_ZERO| in the format text box, and the output value is a zero, no value will be shown.
Examples:
| Test String | Format String | Result
| | 1234567,89 | math ###'#0.00 | 1'234'567.89
| | 1234567,89 | math ### #0.0 | 1 234 567.9
| | 1234567,89 | math $###,#0 | $1,234,568
| | 1234567,89 | math #0,00EUR | $1234567,89EUR
| | 0 | math #0|NO_ZERO| |
|
Boolean Format
This format is used for formatting Boolean values (the values that can only be true or false). False means an empty string or 0, true means any string or number other than zero. Format string example: bool TrueText/FalseText
- TrueText will be printed if the value is true
- FalseText will be printed if the value is false.
Examples:
| Test String | Format String | Result
| | "1" | bool Yes/No | "Yes"
| | "0" | bool Yes/No | "No"
| | "230" | bool Yes/No | "Yes"
| | "" | bool Yes/No | "No"
| | "false" | bool Yes/ | ""
| | "Hello World" | bool Text | "Text"
| | "" | bool Text | ""
|
See Also:
Using Formatting
Formatting Text
Text Formulas
|
