consider the following fields: sales, days in month, terminals.

is it possible to create a calculated field that divides the sum of sales by
the count of terminals??? whenever it try to do this, it uses the sum of
terminals which is not accurate since it adds all transactions for 1
terminal, hence i get a number more than 1 per terminal.
--
jag