Summarise data by a criteria which is in another matrix

Generic selectors
Exact matches only
Search title only
Search in content
Search in all posts
Search in pages
Answers
Questions
Solved466 viewsFormulas and FunctionsAverage select Summary
0

In the attached simple model, I have a table named Marks which contains marks by student by course. In another table named Demographics, I have the students names and gender. I want to populate a third table, named Marks by Gender, based on the average marks by gender for each course. How can I do that ?
Many thanks in advance

Answered question

Attachments

Students.model
1

Hi,
In the Marks by Gender matrix, you can use the following formula as a solution;

: = clearerror(average(Marks::)) using Demographics::Gender as Gender
skip Average of Course

Hope this helps.
James

Selected answer as best
0

Great answer, many thanks

Answered question