...
The Formula Editor allows you to associate a formula with a text field, date field, number field, and so on. Formulas allow you to define relationships between columns in your report. While formulas serve play an important role, they can be difficult to create. The Formula Editor makes the process of creating a formula easy and efficient; it also validates the formula thereby minimizing errors.
Follow the instructions below to create a formula:
- In the Design panepanel, select a field to which you will want to associate a formula.
- In the Properties panel, click Formula to open the Formula Editor.
- In the Format Editor dialog box, select a Category from the list. The Function list is populated with the functions that are most appropriate for the category you selected.
- Select the appropriate function. When you select a function, the Report Editor displays the formula expression (the equation that includes parameters); it also displays the Return Type and Description as shown in the example below:
...