variance-samp

Returns the sample variance of a set of numbers after discarding the nulls in this set.

Note: Supported only in dynamic query mode.

Syntax

variance-samp (  expression [ auto ] )
variance-samp (  expression for [ all|any ] expression { ,
 expression } )
variance-samp (  expression for report )

Example

variance-samp ( Qty )

Result

For each row, returns the sample variance of a set of numbers after discarding the nulls in this set.