todecimal() Function

Function

todecimal( value )

Converts a value to Decimal (double-precision floating-point number).

Parameters

Returns

Decimal

Usage considerations

Numbers less than -10,000,000 and greater than 10,000,000 are represented in scientific notation.

When operating on arrays, it is not necessary to use apply with todecimal. If multiple parameters are passed, or one parameter is an Array, todecimal will return a Decimal Array.

Examples

Convert strings to decimals

1
todecimal("3.6")

Returns 3.6.

1
todecimal("1.123456789")

Returns 1.123457.

1
todecimal("2ab4.57cd3")

Returns 24.573.

1
todecimal("2ab4.57cd3")

Returns 24.573.

1
todecimal("1239329332")

Returns 1.239329e+09.

1
todecimal("string")

Returns null.

Convert a list of strings to a list of decimals

1
2
3
4
{
todecimal("3.6", "4.2"),
todecimal({"3.6", "4.2"})
}

Returns {3.6, 4.2, 3.6, 4.2}. The value can be one or more single values or a list of values.

Feature compatibility

Feedback