SeedCode Support Forum

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.

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.