I really have to apologize, been away from Filemaker for sometime and appear to have forgotten the basics...

I have a few records, 9 now-list layout. I have 2 calculation fields, average and count and they are in the footer below the fields I want to calculate. Record field name is Width.

Average( Column1 ) is showing 840

Count ( Width ) is showing 1

840 is the last number in the list (record 9). If I erase the last number the Average( Column1 ) shows 815, the second to the last number and the Count ( Width ) shows 0.

Why are these fields not calculating all the fields instead of the last field with a value? I know I am overlooking something.

Thanks

Try defining your field as a 'summary' field instead of a 'calculation' field. As a summary field the 'average' function will determine the mean of the designated field in all of the records of the found set.

I believe that when defined as a calculation the average( ) function pertains to the fields of a single record (you wouldn't normally put it in the footer). However, it is useful if you want to average the values of multiple fields on a given record, e.g. average(width; height; depth).

Thanks! Of coarse... it worked.