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()