A value rule is the way in which numbers are calculated in the Fathom forecast main grid. They comprise the rules, formulas or methods for ensuring that numbers are presented on the forecast accurately, and give you ultimate control over the end result.

Methods in Fathom Include:

  1. Direct Entry
    A custom value entered into the forecast grid. This value can come from Excel formulas, other calculation methods, or can simply be a ballpark figure. These are typed into individual value cells.

  2. Link to previous period
    Use actuals from last month, last quarter or actuals from the same month last year. Increase / Decrease by a percentage or dollar amount (% / $).

  3. Smart prediction
    Smart Prediction uses statistical prediction of future values (3/6/12/24 month linear regression) or a rolling average to calculate forecast values. Smart Prediction includes an option for seasonal adjustments when the regression or average is based on 12 or 24 months of data. Using the rolling average to forecast also allows you to incorporate a monthly, quarterly, or yearly increase or decrease into the calculation. For more detail on Smart Prediction, please see our 'Smart Prediction Methodology' article.

  4. Constant/ Growing
    A repeating value that may be increased or decreased each period.

  5. Formula/ Driver
    Launches a formula builder to allow you to customise your calculation, and include drivers/other account values.

  6. Link to Budget
    The value for this account is directly linked to the budget uploaded to the company settings.

Creating a Value Rule

Fathom value rules can be set on the overall heading, subheading or account level by simply clicking on an account or cell. You’ll initially set up the default value rules when you first create your forecast, but these rules can also be edited or changed at any time from the ‘Forecast Settings’ and the main grid.

To create a value rule in the main grid:

  1. Click on an account from the main grid to open the configuration panel on the right hand side of the grid

  2. From here you can view the current rule, and change it by using the ‘three dot’ icon to ‘Edit’ the default rule or add a ‘New rule’.

  3. You can then select from a drop down of choices, and configure those further to suit your needs.

Note: Value rules can only be applied to Profit & Loss headings, subheadings, and accounts. The Balance sheet will automatically generate based on movements in the Profit and Loss.

Did this answer your question?