Formatting functions

The formatting functions impose the display format on the input numeric fields or expressions, Depending on data type, you can specify the characters for the decimal separator, thousands separator, and so on.

The functions all return a dual value with both the string and the number value, but can be thought of as performing a number-to-string conversion. Dual() is a special case, but the other formatting functions take the numeric value of the input expression and generate a string representing the number.

In contrast, the interpretation functions do the opposite: they take string expressions and evaluate them as numbers, specifying the format of the resulting number.

The functions can be used both in data load scripts and chart expressions.

Note: For reasons of clarity, all number representations are given with a decimal point as the decimal separator.

Use the drop-down on each function to see a brief description and the syntax of each function. Click the function name in the syntax description for further details.