average

The average statement calculates averages and sub-averages for the selected records in the current field.


Parameters

No parameters.


Description

This statement calculates averages for the current field. The current field must be numeric. If the database contains summary records, this statement will calculate sub-averages for each summary record, along with an overall average for the whole database. If there are not any summary records in the database, one will be added at the end of the database and the overall average will be calculated and placed into the summary record.

This simple example calculates the average of the Balance field.

field Balance
average

This example calculates the average invoice amount in each state, along with the overall average.

field State
group
field Sales
average

See Also


History

VersionStatusNotes
10.0No ChangeCarried over from Panorama 6.0.