SheetApps User Guide

Calculated measures & percentagesReference

A calculated measure is a formula you name once and reuse anywhere. Add a measure row to your Report_ sheet: its Title is the name, its Measure cell is the formula. Then write that name in any widget's Measure cell:

The KPI shows profit across the (filtered) records — and “Profit” is now available to every chart, pivot and table on the dashboard.

Two ways to write a formula. Over aggregates — sum(amount) - sum(cost), computed once per group — or per record — amount - cost, computed on each row and then summarized. Use aggregates for ratios; use per-record when the math must happen before totalling.

Percentages. Pick % of total or % of group in the Summarize column to read any value as a share. In formulas, pct_of(a, b) is the share a ÷ b, and variance_pct(a, b) is (a − b) ÷ b — both display as percents. A plain ratio like sum(debt) / sum(equity) stays a bare number.

Currency and units follow your fields. A measure built from money shows money — Profit keeps your currency. Multiplying or dividing by a scalar (a constant, a count, or a unit-less quantity) keeps it too, so an average price like sum(line_amount) / sum(quantity) still shows the currency. Mixing currencies, or dividing money by money, falls back to a plain number.

Overriding the display. Wrap a value in scalar(…) to strip its unit on purpose — sum(line_amount) / scalar(sum(quantity)) keeps the currency even when the quantity has units. Or add a Unit column to the measure row to force the format: a currency code (USD), a unit code (KGM), %, or plain.