Find values < or > in comparison fields

General support questions.
Posts: 1
Joined: Wed Jun 14, 2006 9:22 pm
PostPosted: Wed Jun 14, 2006 9:32 pm
I'm trying to do a find which will display only numbers which are greater than or less than a comparison field. For example, I have API scores for schools from 2004 and 2005. I want to do a find which will show ONLY schools which made a gain in their API from 2004 to 2005 or, a find which shows only schools which decreased in their API scores from one year to the next. I'm sure this has to be an easy solution but I can't seem to find a way to get this to work. Any help would be appreciated.
SeedCode Staff
SeedCode Staff
Posts: 2760
Joined: Thu Nov 20, 2003 11:01 am
PostPosted: Thu Jun 15, 2006 7:08 am
Hi. There isn't any way to specify a comparison field directly in a find request. I've always found that a little unsatisfying myself.

What you'll likely want to do is create a calc field or auto-enter calc field that returns the change (or percentage change) in API scores. Then you can perform searches on this field, looking for schools with positive or negative changes.
John Sindelar

Return to General Support

Who is online

Users browsing this forum: No registered users and 1 guest

Follow us: