Derived Metrics V2 — Formula Builder

Formula Chain

Define fallback formulae — evaluated in order until one succeeds

1 / 5 formulae

Preview

Help

Quick Start

A derived metric computes values from other metrics using a formula. Build one in three steps:

Tip: Use the template sidebar on the left to start from a pre-built formula.

Basic Syntax

Reference a metric's value at a time period using brackets:

Revenue[t] - COGS[t]

Supported operators:

+ Add

- Subtract

* Multiply

/ Divide

Use parentheses to control order:

(Revenue[t] - COGS[t]) / Revenue[t]

Time References

Conditional Logic

Actuals & Estimates

Fallback Chains

Derived-to-Derived

Color Legend

Autocomplete