Edit subformula

Subformula Name

Click on the subformula name to edit it. This will update the name of the subformula everywhere it appears. Click outside the text box to continue.

Variables

Click the Add Variable link to add new variables to this subformula. Previously used variables may be selected from the type-ahead list. Or finish typing the name of the variable directly. Then click the Add button to continue.

The default type for all new variables is currency. Change the variable type to a percent or count using the Toggle Type option in the drop-down menu at the right of the row.

Click on an existing variable name to edit it. Note: If this variable is used elsewhere within the model, the variable name will be updated in all places.

If the variable name is used in other places within this model, but requires different data in each place, use the Make Unique option from the drop-down menu. Notice the variable name will be appended with a number, much like a copy of a document on your computer. You may then edit the name of the variable as described above without affecting the other version.

Quantify

Each variable may be quantified directly using the text box in its row. Or use the Find Data option in the drop-down menu. It is a best practice to add the source and any relevant notes associated with this data using the Edit Metadata option in the drop-down menu.

By default, all data is unlocked. Use the Lock for UVPs option in the drop-down menu to prevent this variable data from being changed in Unique Value Propositions (UVPs).

Formula

Define the formula with a mathematical expression using the symbols associated with each variable.

The available mathematical operators include: parentheses, add, subtract, multiply and divide.

You may also use constants, including decimals.

For example: ( (a+b) * 0.75 ) - (c/a)

If the formula is complex or you wish to repeat specific calculations, you may break out any variable into an additional subformula using the Convert to Subformula option in the drop-down menu. Then add variables, quantify, and define the subformula just like the main formula.

Click the function icon at the left to expand or collapse the subformula. And if you decide the subformula is unnecessary, return to the variable options drop-down menu to Eliminate Subformula just as it was added. Note this transforms the subformula into a simple value everywhere it occurs in this value model.

Note: If you have added a variable which you have not used in the formula definition, it will still be saved as part of the subformula within this model. It can then be re-used in other formulas, or added into this one at a later time. Or use the Remove option in the drop-down menu to remove unneeded variables.