Decimal precision seems limited

The decimal data type in Appian seems very limited, e.g. todecimal(100000.99) returns 100001

Any ideas?

https://docs.appian.com/suite/help/18.2/fnc_conversion_todecimal.html

  Discussion posts and replies are publicly visible

Parents Reply
  • Further investigation shows a little more strangeness... if you open a blank expression editor and put in todecimal(1.2345678901234567890) and test the rule, you'll see the rounding you're referring to. However if you then select "Expression" instead of "Formatted" you'll see a longer but still truncated value. This value has about 17 digits, which is more appropriate for a double precision floating point.

    I don't know why the Formatted view is truncating it to a single precision. And when displaying it in a text field you don't have the option to change how the value is shown so this is still an issue.
Children
No Data