Thanking this group in advance for helping.
I work with a school system. We have data related to students. Students are enrolled in a school in the current year - they are considered active students. Each of those will request courses for next school year - we call this schedule_request. The process of requesting courses takes month, but during the process we would want to identify those students who has not completed specific requests.
- For eg. all 5th grade students should have a request for Math course. Under the Math Department, there could be multiple math courses that they can pick from.
- In my dataset, I have listed all active students with their grade level in table 1
- I have another table which lists all the courses they have requested as table2
The question I am supposed to answer is :find out all the students who has NOT selected any courses from MATH department who are in 5th grade.
- I created a table object which only lists current active 5th grade students.
- I have a filter pane which lists departments.
I was trying to use the GetSelectedFields(DEPTNAME) as follows, but the table is not listing any students. I have used similar concept to get counts of students who does not have a specific courses -- but when it comes to a list of students in a table, I am unable to create it.
Only( { <DEPTDESCRIPTION=-{"$(=GetFieldSelections(DEPTDESCRIPTION))"}>} distinct SIS_NUMBER)
Thank you for your help
