Numeric functions

Here is a list of numeric functions supported by Mammoth. In other words, these functions produce numbers as their output.

List of functions supported by Mammoth

Function

Description

COUNT

This function returns the row count.

SUM

This function returns the sum of a given column. This can be be used on numeric columns.

AVG

This function returns the average of a given column. This can be be used on numeric columns.

MIN

This function returns the minimum value of a given column. This can be be used on numeric numeric.

MAX

This function returns the maximum value of a given column. This can be be used on numeric columns.

STTDDEV

This function returns the standard deviation of the values of a given column. This can be be used on numeric columns.

VARIANCE

This function returns the variance of the values of a given column. This can be be used on numeric columns.

INT

This function returns the integer part of the input given to it. For example INT(3.1) = 3, INT(3.9) = 3 This function is supported only in the Math Task. It can be applied on any Arithmetic Expression.