AVERAGE (AVG) (MEAN)
Syntax
Command
Mandatory parameter Optional parameter Mandatory keyword Optional keyword |
AVERAGE (<Source>, <Result>)
Description
When used inside a loop, a 'readfile' loop or 'query' loop and in conjunction with the LEVEL_BREAK command the average value 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 average of. |
| Result |
The name of the object to place the resulting average in. |
Remarks
Average 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)
maximum (rec_lbf.empnr, lay_ftr.maxemp)
variance (rec_lbf.salary, lay_ftr.varsal)
print (lay_emp)
endread
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)
maximum (rec_lbf.empnr, lay_ftr.maxemp)
variance (rec_lbf.salary, lay_ftr.varsal)
print (lay_emp)
endread