### Title

can you calculate the average or mean for a single field

### Post

hello,

i'm working in a filemaker with about 120 records and, want to know the function i'd use to calculate the average for a single age field for all the found records. i know how to get to where to enter the function (ie under specify calulation) but, once i'm there i dont know how to make the field calulate the average once i return back to the form. any help woudl be greatly appreciated..

Thanks! any idea how to count the field ONLY if someone answers yes OR no only (ie ignore one or the other)?

You'll need to add a calculation field (or two) and count (or sum) it. If "yes" and "no" are the ONLY options, you could use 1 and 0 instead - this way you can use Sum and Count directly.

Another option is to produce a report, subsummarized by the field.