AnsweredAssumed Answered

Average function from portal records

Question asked by DavidMenlow on Jun 21, 2011
Latest reply on Jun 21, 2011 by philmodjunk


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,

David Menlow