SUM_SQUARES

Syntax

SUM_SQUARES (<Source>, <Result>)

Description

When used inside a loop, a 'readfile loop' or 'query loop' and in conjunction with the LEVEL_BREAK command the total sum of the squares of the source values between two level breaks is calculated and the result is copied into the result variable.

Diagram

Returned value type

None

Parameters

Parameter	Description
Source	The name of the variable to calculate the total sum of the squares of.
Result	The name of the object to place the resulting total sum of the squares in.

Remark

Sum_squares will only work in conjunction with the LEVEL_BREAK command inside a 'readfile' or 'query' loop.

Example

readfile (lbfile, rec_lbf)
  lay_emp.dept   := rec_lbf.dept
  lay_emp.empnr  := rec_lbf.empnr
  lay_emp.salary := rec_lbf.salary
  lay_hdr.hdept  := rec_lbf.dept
  level_break (rec_lbf.dept, lay_ftr, lay_hdr, 3)
  average (rec_lbf.salary, lay_ftr.avgsal)
  sum_squares (rec_lbf.salary, lay_ftr.sumsqsal)
  std_deviation (rec_lbf.salary, lay_ftr.stdsal)
  sum (rec_lbf.salary, lay_ftr.varsal)
  print (lay_emp)
endread

Return to

Commands