Written by 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 given number into its dollar representation.
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.
Calculates a number raised to a specified exponent.