version 3

Sum squares (series) Number

Parameter | Type | Description | |

series | Field or subfield | Data for which to return the sum of squares | |

Function result | Number | Sum of squares of series |

Description

`Sum squares` returns the sum of the squares of `series`. If `series` is an indexed field, the index is used to find the sum of the squares. You can only use a field with this function when printing a report.

Example

The following example is an object method for the variable `vSquares`. The object method assigns the sum of squares for a data series to `vSquares`. The `vSquares` variable is printed in the last break of the report:

vSquares:=Sum squares([Table1]DataSeries)

The following method is called to print the records in the selection and to activate break processing:

ALL RECORDS([Table1])ORDER BY([Table1];[Table1]DataSeries;>)BREAK LEVEL(1)ACCUMULATE([Table1]DataSeries)OUTPUT FORM([Table1];"PrintForm")PRINT SELECTION([Table1])

**Note**: The parameter to the `BREAK LEVEL` command should be equal to the number of breaks in your report. For more information about break processing, refer to the printing commands.

See Also

Average, Std deviation, Sum, Variance.