### Adding formulas to the view

1. While in the Crystal Dictionary Expert, click the View tab.

2. Click the New Formula button.

   The Insert Formula dialog box appears.

3. Type a name for the formula and click OK when finished.

   The Formula Editor appears.

4. Use the Formula Editor to create a formula for the Dictionary, just as you would create a formula for a report.

   Note: The Crystal Dictionary supports formulas created in Crystal syntax only. See Creating Formulas with Basic Syntax.

   Not all Crystal functions are available in the formula editor in the dictionary designer.

5. Click Accept when finished.

   The new formula is added to the Tables & fields from database list box.

6. To add the formula to the view, highlight the formula you just created in the Tables & fields from database list.
7. Click the Add button. The formula field is added to the Headings & fields in View list.
8. To modify a formula, highlight it and click the Edit button.

Note: Normally, formulas are represented with an @ symbol. The formula name appears in the Headings & fields in View list box without the @ symbol to hide the fact that this is a formula.

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