AMT Help Files
VARIANCE
| Syntax Color Legend |
|---|
| Command |
| Mandatory parameter |
| Optional parameter |
| Mandatory keyword |
| Optional keyword |
Syntax
VARIANCE (<Source>, <Result>)
Description
When used inside a loop, a 'readfile' loop or 'query' loop and in conjunction with the LEVEL_BREAK command the variance 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 variance of. |
| Result | The name of the object to place the resulting variance in. |
Remarks
Variance 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