> ## Documentation Index
> Fetch the complete documentation index at: https://docs.cfo.ai/llms.txt
> Use this file to discover all available pages before exploring further.

# Worked example: Revenue by Department

> See how Revenue, Department, Date, a Scenario, and a saved formula combine to produce one meaningful Model value.

This example shows how Variables, Dimensions, segments, and formulas work together.

## The business question

> How much Revenue did each Department produce by month in the Plan scenario?

## The Variables and Dimensions

* **Revenue** is a Variable. It is the value being measured.
* **Department** is a Dimension. It organizes Revenue by team.
* **Date** is a Dimension. It organizes Revenue by month.

Plan is the Scenario used for the calculation.

## The cell address

One result might be:

> Revenue = 250,000 for Department = Sales in January 2026 in Plan

Revenue is the Variable. Sales is a Department item, January 2026 is the Date period, and Plan provides the Scenario context. Together, the Variable, Dimension item, and period identify the cell address.

## The table

A familiar table might place:

* Revenue on rows
* Month on columns
* Department exposed with **Segment by**.

The layout does not create new business concepts. It arranges the same Variables and Dimensions so people can answer a question.

## The formula

Suppose planned Revenue is calculated as:

```text theme={null}
`Units Sold` * Price
```

Revenue is the target Variable. Units Sold and Price are the referenced Variables. The backticks around `Units Sold` preserve the space in its name.

When the table is broken down by Department, plain references follow the current Department segment. The Sales Revenue cell uses Sales Units Sold and Sales Price when those Variables share the same context.

## A segment-specific exception

If Sales uses a different pricing rule, Revenue can have a more specific formula for Department = Sales. The broader Revenue formula continues to apply to other departments.

Variables hold the values, Dimensions organize them, segments describe meaningful slices, and a cell address identifies one exact result.