### Title

Using List and FilterValue functions with operators

### Post

Still hard at work on a student assessment database. Here's my struggle at the moment. I think it's fairly simple, just having trouble with basic calculation syntax.

I have a table with basic student biographical/contact data and a related table called "sat" of all SAT test dates and scores for students at our school. Students can take the SAT multiple times so there are multiple records for each student in this table. I'm trying to scan the SAT table for any scores over a certain mark...in this case I want scores of 1650 or higher. Currently I'm using the 'List' and the 'FilterValues' functions but I think I'm missing something simple. This is what I have...

FilterValues ((List ( Sat::sat_total )) ; (≥ 1650) )

thanks for any help,

Luis

FilterValues() checks if values in one list

existin the other list - it does not perform calculations or comparisons. If you want to know if a particular student scored 1650 higher on any attempt, try:Max ( Sat::Score ) ≥ 1650