Currency Value

Currency Value

Converts a fully-formatted currency amount (a string) to a numeric value that can be used in calculations. This also supports currency values in exponential forms such as $1.6E8.

If you have not already mapped a field to the Extract number from currency value property, enter a formatted currency amount or click

to open the Path Selector and map a field.

Select the symbol (Period separated fractions or Comma separated fractions) that is used as the decimal symbol in this currency field.

The result of this function always uses a period as the decimal symbol. No currency or thousand separator symbols are included in the result. Plus or negative signs are retained.