is it possible to assign a weight to calculations based on record numbers?
I have a table keeping track of performance.
Is it possible to have a summary field that does something like this:
Score = ((Average of last 10 records) * 0.5 + (Average of records 11 to 30) * 0.4 + (Average of records 31 to 40) * 0.1
Records after 40 are ignored as it would not reflect the current performance of the person.
The order of the records is based on a field that keeps track of the assignment date that this feedback is for.
Thanks in advanced for the help.