Apply one off calculations or add live formulas to build budgets based on other accounts or driver based budgets using Metrics.  




  1. Browse to the Budgets & Actuals menu and select the range of cells that you would like to apply a formula to.

    Note 1: to select a row or column click on the account name or column heading respectively.

  2. Click FORMULA or select it from the 3 dots menu on the range of selected cells.

    Formula button
  3. Set the required properties and click APPLY FORMULA.

    APPLY FORMULA
    Note: see Formula or Repeating Amounts below for details on the required properties.

  4. After applying a formula icons in the budget cells indicate a formula is saved on this cell.

    ONE-OFF formula icon


Formula

Formulas allow you to do account based calculations such as "Sales x 40%" to calculate your Cost of Goods Sold budget or Metrics based calculations such as "Widgets Sold x Widget Price" to calculate your Sales budget. 


  1. Select Formula and choose:
    1. ONE-OFF: calculated when you apply the formula but does not update when related values change.  
    2. or LIVE (Coming Soon): automatically updates as the data source changes. You cannot use LIVE when using Actuals as the Data Source.

  2. Data Source: the data source defines what data will be used in the formula calculation.

    Formula data source
    Actuals or Budget version: defaults to the current budget which you will use for most calculations, however you may wish to use Actuals or another Budget. For example starting with last years actuals or copying from one budget to another.

    Business Unit: defaults to the current business unit which will be used for most calculations, however you may wish to select another business unit or multiple business units. For example to copy from another business unit or to consolidate multiple into different category.

  3. Period: represents the period you want to use in the calculation which is relative to the current period. This defaults to the current period for most calculations however if you wanted to reference Last Years data you would enter the period as -12. You could also reference last month with -1 or 3 months ago with -3.

    Formula data relative period
  4. Formula Definition: the formula calculation consists of 2 sides with an optional operator in the middle.

    Formula calculation
    Left & Right Side: you can add either Accounts, Metrics or Numbers, but only one type on each side. The right side is disabled when the operator is None.

    Operation: single maths operation with options including None, plus (+), minus (-), times(x), divide(÷).

    1. Search for Accounts or Metrics and select the checkboxes to add them to the left or right side. Selecting multiple will sum them on each side before applying the Operation.

    2. When adding a Number to the left or right side you can add numbers and simple maths operations like (133 + 99 -87) * 26 / 12. The result of this will be calculated first before applying the Operation.

      Accounts, Metrics or Number


Repeating Amounts (Coming Soon)

The repeating formula option allows you to set budgets as repeating fixed amounts. For example Wages paid fortnightly or Rent paid weekly where each month may include a different number of payments.