Appearance
What-if
Also known as
- Compare scenarios
- what-if comparison
- what if analysis
- scenario comparison
- side-by-side P&L
- delta
- variance
- sensitivity
- best case worst case
- base vs optimistic
What-if comparison puts up to six scenarios of the same entity side by side as P&L statements, with the difference of each against the first one. Use it to show management the gap between the base, optimistic and pessimistic cases.
Compare scenarios
- Open PlanningWhat-if. With nothing chosen, the page selects up to three scenarios of the newest year, the primary one first. From a scenario, What-if in its header opens the comparison with that scenario.
- In Scenarios, add or remove scenarios (up to six, all of one entity). "The first scenario is the base for the deltas": its column is tagged Base for deltas. To change the base, remove the scenarios and add the new base first.
- Tick Include actuals to date to add a column with the ledger actuals of the year so far.
- Read the table: one amount column per scenario and, after each non-base scenario, a Δ vs {number} column with that scenario's difference from the base and the percentage. Green means better for profit (more revenue or less cost), red worse.
- Scroll down to Net income by month, a chart with one line per scenario.
The URL keeps your choice (?ids=…&actuals=1), so you can bookmark or share a comparison.
Related
- Scenarios and the scenario workspace
- Variance: plan against actuals
- Close and report
- Reports, Dashboards and KPIs
