Use the Formula Builder to create freeform formulas to calculate the historical and/or forecast values of input accounts.

Formulas contain:

  • Values, that are constants or account numbers

  • Mathematical Operators

  • Boolean Operators, such as =,=,< >,#OR#

  • Account References and Functions to reference periods, account values or percentages

Formulas calculate from left to right. To calculate expressions first, enclose them in parentheses.