### Choosing a formula template

###### To choose a formula template

1. Select the template you want to use.

   You can do this in one of two ways:

   - review the list in Record selection formula templates, and write down the formula of interest
   - find the Record Selection Formula Templates in the online help file and copy the formula of interest to the Clipboard.
2. Choose `Edit Selection Formula` from the `Report` menu.
3. Choose Record to create a record selection formula.

   The Record Selection Formula Editor appears.

   - or -

   Choose `Group` to create a group selection formula.

   The Group Selection Formula Editor appears.

4. In the Formula text box, type in the formula you wrote down in Step 1 or paste it from the Clipboard.
5. Replace the values (fields, text, etc.) in the formula with the values you want. For example, if the example formula is:

``{file.FIELD} > 99999``

and you want to limit your report to records for which the value in the {orders detail.QUANTITY} field is greater than 25, replace the existing values with the values you want, so that your selection formula reads:

``{orders detail.QUANTITY} > 25``

1. Click the `Save and Close` button when finished to exit the Selection Formula Editor.

   - or -

   Click `Refresh` on the Standard toolbar to preview the results.

Seagate Software, Inc. http://www.seagatesoftware.com Please send comments to: techpubs@seagatesoftware.com