Changing an existing formula

  1. Open the Formula window in one of the following ways:

    • On the ribbon, from the Calculations group on the Data tab, click Formulas.
    • In classic view, click Database menu > Formulas > Formulas.

  2. Click the list button Image of Ellipsis button to open the Formula List window.

    Tip: You can edit formulas "on the fly" from the Formula List whether you open it from the Database Formulas window or from the Formula Tables or Item Tables window.

  3. Select the formula you want to change, and then click [Edit Formula].

  4. Make changes as needed.

    To change the formula name, click [Rename] and enter the new name in the Formula field.

    For more information, click the Help icon available on the ribbon on the title bar of the window, and then click a field or button.

  5. When you finish changing the formula, click [OK] to save it.

  6. Test the formula to make sure it works properly.

    For more information, see Testing a formula.