Skip to Content
BooksFP&ACreating and running FP&A metrics

Creating and running FP&A metrics

Open FP&A → Metrics to define and calculate metrics for the selected client. Use All metrics for the full list or Custom for formulas you create.

Add metrics from the library

  1. Click Add Metric.
  2. Review each metric’s description, units, and formula preview.
  3. Select the metrics you need.
  4. Use the add button to add the selection.
  5. Check that the metrics appear in the list.

Metrics already in the workspace are marked Added. Expand a shortened description with View more before selecting an unfamiliar metric.

Create a custom metric

  1. Click Add Metric, then Create Custom Metric.
  2. Enter a unique Name.
  3. Choose Units: Number, Currency, or Percent.
  4. Build the formula from the available variables and operators.
  5. Review the formula and correct any validation messages.
  6. Click Save Changes.

The variable picker includes custom variables, profit-and-loss accounts and totals, balance-sheet accounts and totals, and derived values. Search for the account or variable by its displayed name.

Use addition, subtraction, multiplication, division, and parentheses to define the calculation. Use the number control for a constant. Remove an incorrect formula token and replace it before saving. A duplicate name or incomplete formula prevents saving.

Inspect and edit a metric

Open a metric’s view action to inspect its details and readable formula. Use Edit on a custom metric to change its name, units, or formula, then click Save Changes.

A custom formula created as a forecast driver also appears in Metrics. Review where a metric is used before changing it.

Run one or several metrics

Use a row’s run action, or select several rows and click Run with the selected count. The result window opens while the calculations load.

Choose Accounting Basis, Period, and Group By. For a custom period, enter From and To. Changing these controls reruns all metrics in that window with the same scope.

Use each chart’s Area, Line, or Bar selector to change its presentation. Hover over a point to inspect its period and value. Check the formula preview when a result needs investigation. A failed or incomplete calculation is not evidence that the metric is zero.

Remove metrics

Use a metric’s remove action and confirm, or select several rows and click Delete with the selected count. Bulk deletion skips metrics referenced by another formula. Check the result message and resolve those dependencies before trying again.

Deletion is permanent. Switching an account group’s mapping mode can also delete custom metrics that depend on that group; see chart-of-accounts setup.

Last updated on