ToNumber (Convert String to a Number)

The ToNumber function converts a string of characters to its applicable numeric value. Converting data that has been processed as a string to a numeric value allows you to perform various calculations and analysis that can be done only with numeric values.

Syntax

ToNumber(Argument)

Where:

Argument is a fact, metric, column, or constant value that provides the strings that are converted to numeric values. The function can recognize E notation and return the appropriate number.

Example

ToNumber("1001")

This example returns the numeric value 1001.

ToNumber("1.48e12")

This example returns the numeric value 1,480,000,000,000.