Decimal Data Type

• Punctuation such as commas and dollar signs ($) are not supported. These markers must be removed from numeric values through transform steps before you can change the type to Decimal.
• The following range is considered safe for values of this type. There may be inconsistencies in output for values outside this range:
  
  • Safe minimum: 4.9406564584124654e-324
  • Safe maximum: 1.7976931348623157e+308

Notes:

• Decimal values that are longer than 15 digits are treated as String values and may appear as mismatched values in a Decimal column.
• Scientific notation is supported.
• Designer Cloud Enterprise Edition utilizes Java's Float data type for its Decimal data validation, which may result in some loss of precision in rare cases.

Examples:

• 123.45
• 3000.00
• 1.2345678E+22
• 7.4423e-12
• -4.123e+12