Developer

@FROM_SIG_DECIMAL_NUMBER

The FROM_SIG_DECIMAL_NUMBER function sets the context of its single parameter to a data type of decimal number. It supports the decimal number, integral number, string, and property return types. The value of its single parameter will be converted from the decimal number data type to the data type of the context of the FROM_SIG_DECIMAL_NUMBER function call. The decimal number of this parameter will respect the rules of significant digit math.

One of the main uses of this function is to set the context of a decimal value that is either not stored in a decimal property, or one that is stored in a decimal number property but that does not have the significant digits math attribute set.

An optional parameter to this function is Precision. This parameter will specify the number of digits after the decimal to keep, with the last digit being rounded. If the precision is greater than the number of digits after the decimal, the value will be padded with zeros up to the specified precision.

Parameters

    @FROM_SIG_DECIMAL_NUMBER (Convert Parameter [, Precision])
  • Convert Parameter Required decimal number parameter, contains the value that will be treated as a decimal number with respect of significant digit math.
  • Precision Optional integral number parameter, specifies the number of digits to keep after the decimal in the value provided by Convert Parameter. If this value is greater than the number of digits after the decimal the value will be padded with zeros up to the specified precision.

Supported Return Types

  • Integral Number
  • Decimal Number
  • String
  • Property