6 Replies Latest reply on Dec 23, 2009 6:09 PM by bango

Using List and FilterValue functions with operators

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

• 1. Re: Using List and FilterValue functions with operators

FilterValues() checks if values in one list exist in 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

• 2. Re: Using List and FilterValue functions with operators

Looks like the   Max (  Sat::Score ) ≥ 1650 is only pulling out the first related record from SAT Table.  That's why I was trying to use the List function.  Does that make sense?  Is there a better way?

Also, SAT::Score is a calculation field and doesn't work with the max function....correct?  I've made a cahnge to make that work.

thank you.

Luis

• 3. Re: Using List and FilterValue functions with operators

If the calculation is done from the Students table,

Max ( Sat::Score )

returns the highest score of the student among ALL related scores in the Sat table. It shoudn't matter if Score is a calculation field or not.

• 4. Re: Using List and FilterValue functions with operators

Thanks again.  It seems pretty straightforward but I still seem to be getting only the first related record and not the highest score.

• 5. Re: Using List and FilterValue functions with operators

Note Comment's first statement of his last post: "If the calculation is done from the Students table,"

Have you defined this calculation as a field in the students table?

If so, then I suggest analyzing the relationship linking these two tables to see what might not be set up correctly.

• 6. Re: Using List and FilterValue functions with operators
Seems to be working fine.  Thank you.