You use Formula Builder to create freeform formulas to calculate the historical and/or forecast values of input accounts.
Formulas contain these components:
Either constant numbers or account numbers. SeeValues.
Such as +, -, *, /, ( ), ^. See Mathematical Operators.
Such as, >,<,>=,<=,=,< >,#OR#, #AND#. See Boolean Operators.
Account References and Functions
For specifying account values, periods, or percentages. See Functions Referencing Account Time Periods.
Formulas calculate using the standard arithmetic order from left to right: exponentiation, multiplication, division, addition, and subtraction. You enter parentheses around expressions to ensure those expressions calculate first within the order.