What-If Analysis in Zoho Analytics lets you model hypothetical business scenarios by introducing adjustable variables into your reports. Instead of presenting static figures, you can build interactive reports where users control key inputs and instantly see how changes affect outcomes. This makes it a powerful tool for financial modelling, sales planning, and operational forecasting.

How What-If Analysis Works

The foundation of What-If Analysis is the Variable, which acts as a user-controlled input. Variables can be defined as a fixed list of options or as a numerical range. When a user adjusts a variable, all reports and formulas that reference it recalculate automatically in real time.

Setting Up a What-If Model

Follow these four steps to build a What-If scenario in Zoho Analytics:

1. Create Variables: Define the input variables that users will control. These can be configured as a predefined list (such as growth rate options) or as a numerical slider range.
2. Build Aggregate Formulas: Write formulas that reference your variables. For example, a formula might calculate projected revenue by multiplying current sales by a variable growth rate.
3. Generate Reports: Build charts, pivot tables, or summary views that use your formula columns to display the scenario outputs.
4. Add User Filters: Embed the variable controls as interactive filters on a dashboard so that end users can adjust inputs and explore different scenarios themselves.

Advanced Capabilities

• Forecasting Integration: Combine What-If variables with Zoho Analytics forecasting models to project future performance under different assumptions.
• Multi-Variable Formulas: A single formula can reference multiple variables simultaneously, allowing complex scenario models with several interdependent inputs.
• Per-User Variable Restrictions: Administrators can restrict the range or options available to specific users, ensuring that analysts only model within approved parameters.