Editing Formulas Using the Formula Bar

You can use the formula bar to modify a formula within a cell in a grid. The ability to edit a formula with ease is essential, as formula syntax is likely to change for reporting purposes.

  To edit a formula using the formula bar:

  1. Open a report that contains a grid.

  2. Select a formula cell, formula row, or formula column that contains or uses a formula. The associated formula is displayed in the formula bar.

  3. Modify the formula in the formula bar. You can use the drop-down list of functions, to select a formula.

  4. Validate the formula by clicking the check mark, Validation icon, in the formula bar.

    The validated formula is displayed in the formula bar.