## 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.