Constraining Records based on a calculation

[djeans]

I need help figuring out how to constrain a found set based on if one field is within 10% above or below the number in a different field. For instance field one has a value of .75 and field two has the value of 1.25, so being outside the range of 10%, it would fall in the constrained found set. Same would be true if the numbers in the fields were flipped.

Any suggestions?

Thanks

[djeans]

I think I may have figured out a way to do it, but it may not be the best way.

I created a new field that was a calculation to find the difference between the other two fields as a percent, then used the constrain step in my script to only show records where that field was greater than 10 or less than 10.

Thanks.