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

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

 

Outcomes