Use a Custom formula to create your own formula starting with a destination and source. You can create any mathematical expression to suit your business needs. See Using the Custom Toolbar for instructions on adding a source, a function, a number operand, an operator, or parentheses. The default calculation is Destination = Source.
To add a Custom formula to a business rule:
If it is not open, open the graphical business rule to which you want to add a Custom formula.
If the BR Language tab is not selected, select it in the bottom of the left frame of the Analytic Administration Services window.
Expand the Formulas folder, and double-click the Custom formula or drag it to the desired location in the business rule on the Graphical tab.
On the Formula tab, enter details for each operand of the formula. Do the following tasks:
Define the destination for the formula. The destination stores the calculated values from the formula. See Specifying a Destination in a Formula.
Define the source for the formula. See Specifying a Source in a Formula.
Define the ratio by specifying the numerator and denominator, percent to total, percent to parent, or percent to member. See Specifying a Source in a Formula.
Select the Formula Range tab and specify the members that remain constant throughout the formula.
The formula range more narrowly defines the business rule range. See Specifying a Range in a Formula.
Select the Data Condition tab and enter criteria that must be met for the formula to be calculated.