- Create default formulas in specific accounts and levels:The same account can hold a different formula in different levels. For example, a Supplies expense can be calculated one way in Marketing (such as as a function of the number of planned trade shows) and another way in Engineering (such as a function of headcount).
- Modify formulas on levels: For example, a specific Marketing department may require a Supplies expense calculation different from that of other Marketing departments.
- Create formulas as a helpful starting point: Administrators can choose to let individual planners can override a formula or they can configure a formula to prevent changes (read-only).
- Choose whether actuals data should be calculated or imported: Make selections on an account-by-account basis.
Formulas are made up of terms and statements which may be numbers, functions, or references to individual or rollup values of accounts or assumptions. Formulas in different areas of Adaptive Planning generally give access to different types of terms. For example:
When working on sheets, you can input formulas by typing into the formula bar at the top of the sheet 1 or by typing directly into an editable cell of an account or assumption 2. Formula terms may refer to other accounts and assumptions, either individual months or time ranges, and optionally filtered by dimensions.
- Shared Formulas
Home > Formulas lets you enter a formula for a GL or custom account across all months on multiple levels at once. Formulas on this page may refer to any type of term available on a sheet. With the appropriate permissions, users can create local overrides of shared formulas.
- Master formulas
Master formulas are global, account-level formulas that are useful for defining global concepts like Net Income. Master formulas are defined once per account, in the account's definition. Master formulas will be calculated the same on all levels in all versions, are read-only on sheets, cannot be overridden, and perform faster than shared formulas.
- Metric accounts
Metric accounts are accounts that have a single formula as their value and apply across all levels, versions, and time periods. This formula is read-only and cannot be overridden. Metric account formulas are created on the Manage Your Metric Accounts screen, and generally cannot use terms that refer to individual levels or times. Metric accounts created on a cube sheet are called cube metric accounts, and work similarly.
When a formula is used in both actuals and plan, and the formula is the same across all levels and versions, use a metric account for better performance.
- Modeled calculated accounts
Modeled (calculated) accounts are created with the Modeled sheet. When creating formulas for modeled accounts, in addition to referring to accounts and assumptions in your model, you can also refer to columns, lookup tables, and other components of the modeled sheet using modeled sheet formulas.
- Cube calculated accounts
Cube calculated accounts are created in the Cube Sheet Editor. Like modeled accounts, cube calculated accounts can refer to accounts either within or outside the cube. Like metric accounts, cube calculated accounts have a single formula that cannot be overridden and applies to all level and dimension combinations of the account on the cube sheet.
- Custom calculations in reports
Custom calculation elements in matrix reports allow arbitrary formulas, but only terms that refer to other elements on the report or other elements of their tier's dimension. Refer to Formula Syntax for Custom Calculation Elements in Reports.