Use summary function of record subsets with a calculation field?

Discussion created by brentc11 on Jul 8, 2013
Latest reply on Jul 8, 2013 by Mike_Mitchell

I am trying to design a calulation field for a table that uses an average of a selected set of records in the table in the calculation for each record in the table. For instance, you might want to campare the gasoline price for a particular gas station to the average price of a standard subset set of gas stations in the list of gas station prices. What is a good way to do this?