I’m trying to resume some values, but not to sum all the values, just the higher values, for each category.
I’ll try to explain it as clear as I can:
I have a few tables: Exams, Questions, Answers
Each Exam has Questions, and for each question, there is an Answer.
So, the Questions are in Groups. For example: Questions 1-3, Group 1; Questions 4-7, Group 2.
I want to resume all this information in another table, to sum the Answers for each group.
So far so good.
Here is the trick: I just want to sum only the higher 2 values for each category.
Exam 1, Question 1, Answer 4
Exam 1, Question 2, Answer 3
Exam 1, Question 3, Answer 5
So, the Result for the Group 1 for this Exam should be 9 (Answer higher value was 5, next 4, so 5+4)
How do I do this?
This is my first post here, so I’m still figuring out how to use some tools properly.
I’m having a problem and I realize I don’t know CODA enough to solve it.
pd: I used to do this on Excel wih “LARGE” formula
edit: to make it more clear