### 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.

Since your summary field is based on your found set and you've indicated that you will keep the records sorted, try these unstored calculation fields:

cLast10 : If ( Get ( RecordNumber ) > ( Get ( FoundCount ) - 10 ) ; ScoreField )

cLast11_30 : Let ( [ Fc = Get ( FoundCount ) ; N = Get ( RecordNumber ) ] ; If ( N > ( Fc -30 ) and N < ( Fc - 9 ) ; ScoreField ) )

cLast31_40 : Let ( [ Fc = Get ( FoundCount ) ; N = Get ( RecordNumber ) ] ; If ( N > ( Fc -40 ) and N < ( Fc - 29 ) ; ScoreField ) )

Define sAvg10, sAvg11_30, sAvg31_40 as the average of these three fields.

Then use this calculation:

sAvg10 * 0.5 + sAvg11_30 * 0.4 + sAvg31_40 * 0.1