Changing an existing formula (SQL)

Resolution

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 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.

  1. Select the formula you want to change, and then click [Edit Formula].
  2. Make changes as needed.

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

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

  1. When you finish changing the formula, click [OK] to save it.
  2. Test the formula to make sure it works properly.

Need more help?

Chat now

 

Solution Properties

Solution ID
230605180907227
Last Modified Date
Mon Jun 05 18:09:06 UTC 2023
Views
0