stddevc()

Function group Execute on client Platform(s)
List NO All

Syntax

stddevc(listname,column[,ignore-nulls])

Description

Returns the standard deviation for a list column specified by listname and column. stddevc() can only be used with columns defined using variables so it cannot be used with lists defined from a SQL class.

If you set ignore_nulls to 1, null values are ignored and not counted. If you omit this parameter or it evaluates to zero, nulls are treated as zero values and are counted.

Example

Calculate lResult as jst(stddevc(lList,lCol1),'N2')
; returns the standard deviation rounded to 2 decimal places