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:
- 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.
- 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 (% / $).
- Smart prediction
Statistical prediction of future values (3/6/12/24 month linear regression), with an option for seasonal adjustments. Note: Smart prediction will only allow for seasonality if 24 month regression is chosen.
- Constant/ Growing
A repeating value that may be increased or decreased each period.
- Formula/ Driver
Launches a formula builder to allow you to customise your calculation, and include drivers/other account values.
- 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:
- Click on an account from the main grid to open the configuration panel on the right hand side of the grid
- 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’.
- 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.