{{getMsg('Help_YouAreHere')}}:
/
{{page.title}}
{{page.title}}
{{$root.getMsg("downLoadHelpAsPdf")}}
{{helpModel.downloadHelpPdfDataStatus}}
PopulationStdDev
Returns the population standard deviation, calculated by taking the square root of the variance over all records or array elements.
Usage:
PopulationStdDev( fld ) PopulationStdDev( fld, condFld ) PopulationStdDev( fld, condFld, cond ) PopulationStdDev( array )
Parameters:
fld | The name of a field whose values should be used to calculate the population standard deviation. |
---|---|
condFld | The name of the field that groups the values of fld (if fld isn't an array). |
cond | A string declaring the type of grouping to be used on condFld. This only makes sense for groups based on Date, DateTime, Time, and Boolean fields. See Summary Field Conditions for a list of strings you can use here. |
array | The name of an array variable whose values should be used to calculate the population standard deviation. |
Returns:
Numeric value.
Examples:
PopulationStdDev({data.Temperatur}, {data.Region}) //returns the value of variance for a field Temperature grouped by Region.
PopulationStdDev([{f1}, {f2}, {f3}, {f4}]) -> 3,57 (assuming that f1=2, f2=2, f3=10, f4=8)
Notes:
-
If the values in fld should be grouped, a group based on condFld is needed. If the group does not exist in the report, you can add it using i-net Designer or using API method: Engine.addGroup.