Examples
DECIMAL(4) : 0 (0.0)
DECIMAL(10 / 3) gives 3 (3.0). In AppSheet, a Number (10) divided by a Number (3) always produces a Number (3). In this example, the DECIMAL() function merely converts the Number result (3) to a Decimal value (3.0).
(10 / DECIMAL(3)) gives 3.33. In AppSheet, a Number (10) divided by a Decimal (3.0) always produces a Decimal (3.33). In this example, the DECIMAL() function converts a Number (3) to its Decimal equivalent (3.0).
(DECIMAL(10) / 3) gives 3.33. In AppSheet, a Decimal (10.0) divided by a Number (3) always produces a Decimal (3.33). In this example, the DECIMAL() function converts a Number (10) to its Decimal equivalent (10.0).
DECIMAL("4.2") gives 0 (0.0). AppSheet recognizes quoted raw text values in certain formats as Date, DateTime, or Time values. In this example "4.2" is recognized as the date, April 2 (of the current year). A Date value has no Decimal equivalent, so 0 (0.0) is returned. This (mis-)interpretation of the input only affects raw text values; an input from a column value or the result of another expression would not be so affected.
DECIMAL("14.2") gives 14.2. Unlike the preceding example, the quoted raw text value of "14.2" does not correspond to a valid Date, DateTime, or Time value, allowing DECIMAL() to work with the given text and to give the expected result.
DECIMAL("Hello!") gives 0, as the input value in no way resembles a numeric value.
DECIMAL("") gives a blank Decimal value.
Syntax
DECIMAL( any-value )
Argument
any-value (any)
Return Value
Decimal: The decimal equivalent of any-value if a recognizable number, or 0 if not. If any-value is blank (e.g., ""), the result will be a blank Decimal value.
See Also
APP(), DATE(), DATETIME(), NUMBER(), TEXT(), TIME()