AnsweredAssumed Answered

is it possible to assign a weight to calculations based on record numbers?

Question asked by DarrenFrancis on Jul 23, 2012
Latest reply on Jul 24, 2012 by DarrenFrancis

Title

is it possible to assign a weight to calculations based on record numbers?

Post

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.

Outcomes