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 ----------