There are several zMUD functions that loop through a specific column in a view automatically and compute a result. The first argument to these functions is the name of the Column (field) to loop through. The second argument is optional and specifies the View|Database name to use. If missing, the current view and database is used. A complete list of these functions are:
For example, %sum(Hit) would return the sum of the Hit field for all records in the View. %dblist(Name) would return a string list of all of the record names in the current view. For the most part, these formulas are intended for use in a pivot table (see Advanced Database usage), but can be used for any other purposes.