List of Expressions

For an introduction to calculated fields, check out Working with Calculated Fields.

Aggregations

• Average
  Returns the average of the values in the column.
  Syntax: avg(column) -> double

• Count
  Returns the count of non-null rows (also known as records) in the selected data.
  Syntax: count(column) -> bigint

• Max
  Returns the largest value found in the column.
  Syntax: max(column) -> [same as input]

• Min
  Returns the smallest value found in the column.
  Syntax: min(column) -> [same as input]

• Sum Adds up all the values of the column.
  Syntax: sum(column) -> [same as input]

Math functions

• Absolute
  Returns the absolute (positive) value of the specified column.
  Syntax: abs(column) -> [same as input]

• Cube root
  Returns the cube root ofthe number.
  Syntax: cbrt(column) -> double

• Ceil
  Rounds a decimal up (ceil as in ceiling).
  Syntax: ceil(column) -> [same as input]

• Exponential
  Returns Euler's number, e, raised to the power of the supplied number.
  Syntax: exp(column) -> double

• Floor
  Rounds a decimal number down.
  Syntax: floor(column) -> [same as input]

• Ln
  Returns the natural logarithm of?the number.
  Syntax: ln(column) -> double

• Log10
  Returns the base 10 log of the number.
  Syntax: log10(column) -> double

• Round
  Rounds a decimal number either up or down to the nearest integer value.
  Syntax: round(column) -> [same as input]

• Signum
  Returns the signum function of the number.
  Syntax: sign(column) -> [same as input]

String functions

• Length
  Returns the number of characters in string.
  Syntax: length(column) -> bigint

• Reverse
  Returns string with the characters in reverse order.
  Syntax: reverse(column) -> varbinary