AnsweredAssumed Answered

How to get a summary over last 10 records only?

Question asked by ThomasM_1 on Oct 21, 2013
Latest reply on Oct 23, 2013 by ThomasM_1

Title

How to get a summary over last 10 records only?

Post

     I need to know the average of field A for the last 10 records (based on a date field B) whose field A is not empty. I need to have this information in a field and cannot use a script performing a search for the last 10 records.

     I thought of using a summary field on A with a weighted average relative to a calculation field. This calculation field should be boolean and simply indicate whether the record is part of the last 10 records. However, I could not find a way setting up this calculation field. Maybe there is even another and better approach. Please let me know.

Outcomes