I have a summary which is "Average of Amount" which gives incorrect value so I made a new file to figure it out.  In my test I have 10 records in the found set which each holds a '1' in the Amount field except for one field which is empty.  The result of this summary is 1.  It should be .9.  In Help I search for Summary and nothing comes up.  It is not listed in functions reference and I found "Summary functions"  but it only lists GetSummary.  Ideas what I have wrong in this summary?  thank you for reading

Summary fields do not count empty records (or, for the purpose of averaging, records containing non-numeric values). To force the behavior you want, use a total divided by Get (FoundCount).

Edited December 19, 201510 yr by comment

And again, Comment, I am grateful for your help and that works.  I found http://www.filemaker.com/help/11/fmp/html/create_db.8.16.html but it doesn't mention empty fields are skipped either.  It seems a glaring omission.

32 minutes ago, rob said:

it doesn't mention empty fields are skipped

Well, there is a hint in:

Quote

Count of     Counting the number of records that contain a value for the field.

But I will not argue in defense of Filemaker's help.