COUNTROWS(<table expression>) → int
FILTER(<table expression>, <criterion>) → table expression
DISTINCT(<column expression>) → column expression
BLANK() → null
ISBLANK(<value expression>) → bool
SUM(<column expression>) → number
Returns the sum of all values in <column expression>.
SUMX(<table expression>, <numeric expression>) → number
Returns the sum of <numeric expression> evaluated for each row in <table expression>.
PRODUCT(<column expression>) → number
Returns the product of all values in <column expression>.
PRODUCTX(<table expression>, <numeric expression>) → number
Returns the product of <numeric expression> evaluated for each row in <table expression>.
AVERAGE(<column expression>) → number
AVERAGEX(<table expression>, <numeric expression>) → number
Returns the mean <numeric expression> evaluated for each row in <table expression>.
COUNT(<column expression>) → number
Returns the number of rows in <column expression> in which the expression is non-empty (i.e. ISEMPTY(<column expression>) = false).
COUNTX(<table expression>, <expression>) → number
Returns the number of rows in <table expression> in which <expression> is non-empty.
MAX(<column expression>) → number
Returns the largest numeric value in <column expression>.
MAXX(<table expression>, <numeric expression>) → number
Returns the largest <numeric expression> evaluated for each row in <table expression>.
MAXA(<column expression>) → number
Returns the largest value in <column expression>, including text and booleans.
CONCATENATE(<text expression>, <text expression>) → text
Concatenates two <text expression> values together.
CONCATENATEX(<table expression>, <text expression>) → text
Concatenates the result of <text expression> evaluated for each row in <table expression>.