Tables and data

Formulas

A value worked out from other columns, live, never typed.

A Formula column computes its value from other columns in the same row — it's never typed and never stale. Reference columns by name in curly braces:

{Amount} * {Commission %} / 100

Formulas support + − × ÷ and parentheses, can reference number, currency, and other formula columns, and can display as a number or as currency. Circular references are detected and refused rather than looping.