Creating and modifying formulas

Creating a formula and inserting it into a report

1. On the Insert menu, click Formula Field.

   The Field Explorer dialog box appears.

   

2. Select Formula Fields.
3. Click New.
4. In the Formula Name dialog box, enter the name you want to identify the formula.
5. Click OK.

   The Formula Editor appears.

   

6. Choose either Crystal or Basic syntax.

   If you are unsure which syntax to choose see Formula syntax.

7. Enter the formula by typing in the components or selecting them from the component trees.
8. Click Check to identify any errors in the formula.
9. Fix any syntax errors the Formula Checker identifies.
10. When the formula has the correct syntax, click Save then Close.

    You return to the Field Explorer dialog box.

11. Double-click the formula and position the cursor where you want the formula to appear on your report.
12. Click once to set the field in the desired position.

Note:    A formula that is placed on a report is indicated by @ (e.g. @ProcessTime).

Related topics

Creating Formulas with Basic Syntax.

Creating Formulas with Crystal Syntax.