ToString (Convert Number, Date, or Timestamp to a String)

The ToString function converts a number, date, or timestamp to a string of characters. Converting data that has been processed as a numeric, date, or timestamp value to a string allows you to view and display the data in different ways.

Syntax

ToString<Pattern=null>(Argument)

Where:

• Argument is a fact, metric, column, or constant value that provides the values that are converted to a string of characters.

• Pattern is a parameter that determines the formatting for the resulting string of characters. When providing a pattern, enclose the pattern in double quotes (""). For example:

  ToString<pattern="0,000.00">(Revenue)

  To specify a pattern, you can use the custom numeric, date, and time formatting symbols that are described in the Advanced Reporting Help.

Example

ToString<pattern="0,000.00">(1001)

This example returns the string "1,001.00".