AVERAGEX
The AVERAGEX function returns the arithmetic mean of the values returned by an expression that is evaluated for all rows in a table.
STDEVX.P
The STDEVX.P function returns the standard deviation of the entire population extracted from a table to whose rows a certain expression is applied.
STDEVX.S
The STDEVX.S function returns the standard deviation of a sample of the population drawn from a table to whose rows a certain expression is applied.
VARX.P
The VARX.P function returns the variance of the entire population extracted from a table to whose rows a certain expression is applied.
VARX.S
The VARX.S function returns the variance of a sample of the population extracted from a table to whose rows a certain expression is applied.
COUNTX
The COUNTX function counts the number of rows in a table for which the evaluation of an expression returns a number, a date, or a text.
COUNTAX
The COUNTAX function counts the number of rows in a table for which the evaluation of a certain expression returns nonblank values.
RANKX
The RANKX function returns the position or rank of each value resulting from applying an expression to the rows of a table comparing them with each other.
TOPN
The TOPN function returns the N rows with the highest values from the indicated table.
USERELATIONSHIP
The USERELATIONSHIP function specifies the relationship between two tables to use in a calculation.
