Hi,

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.

For example:

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