Solution Properties
Solution ID:
230605180907227
Last Modified Date:
Mon Jun 05 18:09:06 UTC 2023
Taxonomy Path:
Case category//How do I...
Author:
[email protected]
Changing an existing formula (SQL)
Description
Cause
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.
[BCB:164:Chat Estimating US:ECB] 
Steps to duplicate
Related Solutions