### Title

Working out the mean of a set number of records

### Post

Iam trying to work out the mean of a set number of related records say the last 5 records. Iam just wondering whats the best way to get the data from the last five records to work the mean out?

Ive have the data displayed in a portal

Thanks Jon

You have two options you can explore: Average ( RelatedTable::Datafield ) and a summary field defined in the portal table that computes the "Average of" this same field.