NUMBERVALUE

The NUMBERVALUE function converts text to a number, correctly handling different decimal and thousands separators such as commas and periods.

Syntax

numbervalue(text, decimal_separator, group_separator)

Arguments

text - Required. The text to be converted to number.

decimal_separator - Optional. The character used to differentiate between the integer and the fractional part of a number.

group_separator - Optional. The character used as a thousand separator.

Example

NUMBERVALUE("2.456,78", ",", ".")

Returns 2456.78.

In this example, the Interest column is a data input field with text data. We've used the NUMBERVALUE function to convert the Interest text field to a numeric field that aligns with the other measures in the report.

Using the NUMBERVALUE function to convert the Interest text field to a number