Jump to content

Find values < or > in comparison fields


cfahle
 Share

This topic is 5646 days old. Please don't post here. Open a new topic instead.

Recommended Posts

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.

Edited by Guest
Link to comment
Share on other sites

Assuming Comparison is a global and if I understand correctly, this will work:

Set Error Capture [ On ]

If [ not Comparison ]

Show Custom Dialog [ "No value in Comparison" ]

Halt Script

End If

Enter Find Mode [ ] ... uncheck Pause

Set Field [ API ; ComparisonField ]

Perform Find [ ]

If [ not Get ( FoundCount ) ]

Show All Records

End If

Show Omitted Only

This performs a find for all records EQUAL to the Comparison number then omits them, leaving those that are less than or greater than Comparison number. If no records are found matching Comparison, then all records are shown because all records will be less than or greater than Comparison.

LaRetta

Link to comment
Share on other sites

This topic is 5646 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.