There are four different kinds of elements that can be part of a formula: dimensions, operations, literal values, and combined formulas. These elements are selected while building a formula in the Edit Formula.
To add or edit a Formula, highlight its line first. Then, there are several ways to access the editing display:
Highlight the formula that you want to edit and select Edit > Edit.
Right-click the formula and select Edit Item.
The “Edit Formula” window displays.
The Dimension, Value, and Formula radio buttons are used to enter a formula.
Notes:
|
As you select dimensions, operations, etc. notice that the formula is being "built" in the Formula field (below Description).
Select .
The program checks the formula for combined formulas, that have been used
that reference the current formula, which would result in a "loop."
If the formula passes the test, “The
formula test passed” displays. Select OK
to return to the Edit Formula display). If the test fails “The formula contains a circular combination”
displays. You must correct the error before you will be allowed to select
OK in the “Edit Formula” display.
When are finished working with this formula, select OK to save your changes. If you do not want the changes that were made to be saved, select CANCEL.