Configuration formulas allow you to define a mathematical expression to calculate numeric values used in either Conditions or Actions. Configuration characteristic values and quantities, combination table return values, as well as other formulas, can be used as values in the formula.
A formula is defined by decomposing the mathematical expression to its basic elements: values, operators, and functions. Thus, a formula such as WIDTH * LENGTH is broken into three elements:
The system offers a number of different mathematical operators and common SQL data functions as part of the syntax. Formulas have a basic testing mechanism and a state to indicate whether they are ready for use in configuration rules (see Back Office Configuration Rules).