A
Asoka Walpitagama - Brandix College IT
Hi
How do I calculate the Cumilative total ( ?? ) depending on the rank as show
below. I have given the way it should be calculeted in the 'RESULT SHOULD BE'
column
RANK Length Cum Tot RESULT SHOULD BE
2 65 ?? 70+65 ( Cum.tot of Ranks 1 + 2 )
3 60 ?? 70+65+60 ( Cum.tot of Ranks 1 + 2 +
3 )
1 70 ?? 70 ( Cumilative total
of Rank 1 )
5 45 ?? 70+65+60+55+45 (Cum. tot of Ranks
1+2+3+4+5)
4 55 ?? 70+65+60+55 ( Cum. tot of Ranks
1+2+3+4 )
How do I calculate the Cumilative total ( ?? ) depending on the rank as show
below. I have given the way it should be calculeted in the 'RESULT SHOULD BE'
column
RANK Length Cum Tot RESULT SHOULD BE
2 65 ?? 70+65 ( Cum.tot of Ranks 1 + 2 )
3 60 ?? 70+65+60 ( Cum.tot of Ranks 1 + 2 +
3 )
1 70 ?? 70 ( Cumilative total
of Rank 1 )
5 45 ?? 70+65+60+55+45 (Cum. tot of Ranks
1+2+3+4+5)
4 55 ?? 70+65+60+55 ( Cum. tot of Ranks
1+2+3+4 )