Written by Determines the average of the absolute deviations of values from their overall mean.
Transforms a given numeric value into a string format.
Transforms a given date/time, percentage, currency, or any formatted numeric value into a raw number, stripping away all formatting.
Transforms a given number into its percentage equivalent.
Transforms a supplied numeric value into a date format.
Transforms a numeric value into another unit of measurement.
Returns a specified number without any alterations.
Returns distinct rows from the specified source range while omitting duplicates. The order of rows in the result reflects their initial appearance in the source range.
Returns a value treated as a percentage; for example, `UNARY_PERCENT(100)` evaluates to `1`.
Provides a numerical value with the sign inverted.