4D v13.4
Sum squares
- 4D Language Reference
-
- On a Series
-
- On a Series
- AverageUpd
- MaxUpd
- MinUpd
- Std deviationUpd
- Sum squaresUpd
- SumUpd
- VarianceUpd
Sum squares
| Sum squares ( series ) -> Function result | ||||||||
| Parameter | Type | Description | ||||||
| series | Field, Array |
|
Data for which to return the sum of squares | |||||
| Function result | Real |
|
Sum of squares of series | |||||
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 pass an array (one or two dimensions) in series. In this case, the array must be of the Integer, Longint or Real type.
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 chapter Printing.
This example gets the sum of the squares of the values placed in an array:
ARRAY REAL($ArrGrades;0)
QUERY([Exams];[Exams]Exam_Date=!01/07/11!)
SELECTION TO ARRAY([Exams]Exam_Grade;$ArrGrades)
vSumSquares:=Sum squares($ArrGrades)
Product: 4D
Theme: On a Series
Number:
28
Created: < 4D v6
Modified: 4D v13
Average
Std deviation
Sum
Variance
