Sample FormulasNote: Standard formulas (those with the System Formula field selected) cannot be changed.
On the Edit Report screen for the selected report, click the Formulas button or select the Maintenance menu and then Formulas.
Note: If the report to edit is not yet open, first complete the following: from the Report Writer screen, click on the name of the view group in the Report Groups List that contains the report with the formula to change and click on the name of the report to edit in the Reports List (or click the Find button instead to search for the desired report); then click the Edit Record button located at the top of the screen.
At the Formulas screen, enter the name of the formula to change in the Formula Name field. If the name is not known, click the down-arrow button or the Find button to select the correct one.
Make the desired changes to the formula.
Click the Check Formula button to have the system check the formula for errors.
A message will appear in the status bar stating if there are any errors in the formula or if the formula was validated.
Note: If there is an error, be sure to correct the error before continuing.
Click the Save button to save the changes to the formula.
If the Formula Name was changed, a prompt will appear verifying whether or not to change the name of the formula or add a new formula. To change the name of the formula, click the Change button. To not change the name and revert to use the original name, click the Revert to Original button. To add a new formula with the specified name that is a duplicate of the current formula, click the Create New button.
Click the X in the upper right-hand corner to return to the Edit Report screen.