Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
HI friends
i have a table student with two columns student id and marks.
Data set as shown below
student id. Marks
15. 42
14. 39
13, 22
11, 18
10. 90
9. 72
8. 33
7. 43
6. 11
5. 17
4. 38
3 66
2. 74
1, 10
now i wanted so consider latest 11 points i.e frpm15 to 5
then i need average of top 5 and avg of last six that
You need this in a text box object?
May be this in a text box object
For Top 5
=Avg(Aggr(If(Rank(If(Rank([student id]) <= 10, Marks)) <= 5, Marks), [student id]))
For Bottom 5
=Avg(Aggr(If(Rank(If(Rank([student id]) <= 10, Marks)) > 5, Marks), [student id]))
NOTE: 15 to 5 are just 10 data points so I used Bottom 5 instead of bottom 6 here
yes