Reducing a found set of records by a second field
If have written a script that finds a group of records to do a series of reports. The last report I want to do is based on a sub-set of the records used in the previous reports. I have one field that I'm trying to condition the new sub-set on and I'm having issues getting it to work. What is the correct logic to use in the script?
The sub-set of records is to be constrained or filtered based upon the following: "Sales Price" > 0
Any help would be appreciated.
You can either do another find with the first criterion, and with this second criterion added to the same request. Or you could apply 'Constrain found set' using that script step.