Assign rank to each student based on its Total Marks

Help Activities
, ,
1

  1. Count At_Kt as 1 if subject Mark is less than 40 and calculate total nos of At_Kts. Eg: If any student has less then 40 marks in 2 Subject then ATKT count is 2 ,.If any student has less then 40 marks in 3 subject then ATKT count is 3

  2. Assign rank to each student based on its Total Marks. (Ex…For highest marks rank should be 1 and so on.) note: if someone have aktk then rank will be NA.
    Marksheet Data.xlsx (11.6 KB)

Thank you in advance

1 Like
2

Hello,

Can you check the below post. It will help to get the ATKT count. Same like that you can add a column for total mark of student(sum of all subject). Based on that you can use a Sort activity and sort the rows.Then give the rank.

1 Like
3

Hey @Ashok_kumar7

Were you able to get solution for this ?

Thanks
#nK

4

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.