AnsweredAssumed Answered

Using List and FilterValue functions with operators

Question asked by bango on Dec 22, 2009
Latest reply on Dec 23, 2009 by bango


Using List and FilterValue functions with operators


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 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,