How to get a summary over last 10 records only?
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.