How to use Standard Devian and Median functions in BI Answers?

StdDev

Returns the standard deviation for a set of values. StdDev_Samp is a synonym for StdDev.

Syntax
StdDev([ALL | DISTINCT] numExpr)
StdDev_Samp([ALL | DISTINCT] numExpr)

Where:

numExpr

Any expression that evaluates to a numerical value.

ALL

The standard deviation is calculated for all data in the set.

DISTINCT

All duplicates are ignored in the calculation.


Median

Calculates the median (middle) value of the rows satisfying the numeric expression argument. Where there are an even number of rows, the median is the mean of the two middle rows.

Syntax
Median(numExpr)

Where:

numExpr

Any expression that evaluates to a numerical value.

Until Next Post... :)