Inserting a Formula
You can insert a formula in the open Report Design file from the Formulas window.
1. If the Formulas window is not open, select Insert > Formula to open it.
2. In the Formulas window, click Add.
The Edit Formula window opens. Formula name and Formula text appear on all three pages of this window. The following table describes these two properties.
Property
Description
Formula name
The unique and descriptive name assigned to the formula.
Formula text
The equation associated with the formula. To insert a database function, data field, or group in the equation, you can double-click an entry in the lists on the Functions, Data Fields, and Groups pages. Additionally, you can use the standard Windows drag-and-drop technique to drag an entry from its respective list to this property.
3. Complete these two properties using the Functions, Data Fields, and Groups pages as necessary. For more information, see:
4. When finished, click OK to save the formula to the list in the Formulas window. If you click Cancel instead, this formula is not saved. Clicking either of these buttons closes the Edit Formula window.
5. Use the windows drag-and-drop technique to insert the formula in the appropriate location in the Report Design file.