Financing
You can see the formulas behind the amounts instead of their results, and know when that view is the one to work in.
An amount cell normally shows what it works out to. The **fx** toggle in the toolbar switches the grid to show the **formula** behind each amount instead.
A plan whose amounts are formulas looks, in the ordinary view, exactly like a plan of typed numbers. The values view answers *how much*; the formula view answers *why that much*.
Turn it on when you are:
- **auditing a plan** — especially one you inherited, where the difference between a fund that is 20% of German spend and a fund that is a fixed €400,000 matters enormously; - **checking after a relink** — a copy onto another budget leaves formulas as text, so a reference the new budget lacks resolves blank. The formula view shows which reference; - **repeating a pattern** — reading one source's formula before writing the next.
Sources with a typed number show that number. Sources with a formula show the expression — `NPC * 0.2`, `ACCOUNT("3.01")`, `SUM_TAG_F("regional")`. The distinction is the point: at a glance you see which of your financing is a rule and which is a fixed figure.
Toggling changes nothing in the plan. Amounts, totals and the rail are unaffected — you are looking at the same data a different way, and toggling back costs nothing.
Leave it on while you work through formulas, off when you are reading money.
Markdown