7.81 KEEP_AVG
The KEEP_AVG command is used to keep the average of field(s) in another field.
The KEEP_AVG command is only valid within SELECT or SELECTLIST command loops, because the processing logic used is implicitly linked to the SELECT / SELECTLIST loop logic.
Normally the KEEP_AVG command is entered directly after the SELECT or SELECTLIST command. However there are specific exceptions to this. Refer to the examples section for more details.
Also See
7.81.2 KEEP_AVG Comments / Warnings
Required
KEEP_AVG --- OF_FIELD ---- list of field names --------------->
| expandable group expression |
------ -- 50 max - -----------
IN_FIELD ---- field name ---------------------->
-----------------------------------------------------------------
Optional
BY_FIELD ---- *SELECTED -----------------------|
list of field names
| expandable group expression |
--------- 20 max ----------