Creating and Editing a Formula

The Data Browser enables you to define formulas (freeform expressions) that define the values and filters of a widget.

A rich variety of functions are provided for you to use in the formula that you define.

To define a formula:

  1. Open the formula editor in the Data Browser:
  2. Define the formula as follows:
  3. Type in the required parts of the formula. To see examples, see Formulas Based on Criteria and Conditions, and Functions to Build Formulas.
  4. Click OK.

To edit a formula:

You can easily edit formulas using the right-click options. They include:

The following image shows the right-click options.

The following image shows right-click options for a filtered formula. Read more below.