Dear All,

I have collated 78 Excel Spreadsheets representing, (excluding missing data), every month from 2010 to date, of UK's Nursing and Midwifery Council's Sanctions and Restrictions.

I have managed to put average, (and standard deviation), of each sanction. I have even managed to create a flexible weighting system to compensate for the effects of double counting. But there are still some questions I would need to ask:

- Does Filemaker allow for Yearly Averages, i.e. Average for 2010, Average for 2011, etc?
- If Filemaker does allow the above, what would be the commands?
- Also can it be done within the same field, or does each year require a seperate field.

If the above is possible, it would help me with developing my knowledge of Filemaker.

Many thanks

Dominic Joannou

If you create a calculated field Year from your DateField that does Year( DateField). Then you create a Statistic Field of Average and then in your list layout do a sub summary report you sort on your new Year field and put the new Statistic Field in that part you will get Average of each year

You can also do this with ExecuteSQL, but a list view with running Average for each year will make more sense for what you are asking for.