Average function from portal records
This may end up being a simple answer, but I am unfamiliar with how to apply the 'average' function to a specific field displayed in a portal. Here is what I need. The file in which I have the portal displaying data is called Current. The data in the portal is from a file called Historical. The Historical file contains about 15,000 records. The portal sorts and dislays the records from the Historical file on a descending order by date. One of the fields displayed in the portal calculates a percentage of some data in that Historical file, which I will call Percentage. What I am looking for is to be able to take just the 1st 10 records displayed in a portal from this file and calculate an average of the field Percentage to just those 1st 10 records. Some records may not show 10 records from the Historical file. I have no idea where to even start with this, if it can done at all.
I have attached a screen shot of what this looks like. All 4 of the portals display records from the Historical file and the colored boxes are the percentage fields that I need averaged.
Thanks for your help,