What if analysis report

Note: you can only use a single parameter for a single input. You will note that any parameters included in those calculations will now appear in the filters section of your report data.

This is because the parameter is treated somewhat like a user prompt filter. On the report preview page you will be able to format your parameters to create dials and sliders for numeric fields.

Click on the Filters tab at the top of the page and select the parameter you wish you format. From here you will be able to edit the parameter options such as name and format etc.

The default value used to ensure that the parameter can work even if the user doe not immediately enter a value. Enter an appropriate value for your parameter. What-if analysis Analytics Plus enables you to perform powerful scenario analysis over your data using the What-if analysis feature. Setting up What-if analysis Follow the steps below to configure scenario analysis, the follow Creating a variable Adding variable to an aggregate formula Adding the variable as a user filter Step 1: Creating a variable To provide a dynamic input for what-if analysis, a variable should be created.

Step 2: Adding variable to an aggregate formula On creating a custom variable, you need to create an aggregate formula using the created variables. Step 3: Adding the variable as a user filter Navigate to the report you wish to analyze, and add the required variable as a user filter to the report. Was this article helpful? Yes, thanks!

Not really. By using Solver, you can find an optimal value for a formula in one cell—called the target cell—on a worksheet. Solver works with a group of cells that are related to the formula in the target cell. Solver adjusts the values in the changing cells that you specify—called the adjustable cells—to produce the result that you specify from the target cell formula.

You can apply constraints to restrict the values that Solver can use in the model, and the constraints can refer to other cells that affect the target cell formula.

You can always ask an expert in the Excel Tech Community or get support in the Answers community. Goal Seek. Data Tables. Using Solver for capital budgeting. Using Solver to determine the optimal product mix. Define and solve a problem by using Solver. Analysis ToolPak Add-in. Overview of formulas in Excel. How to avoid broken formulas.

Detect errors in formulas. Keyboard shortcuts in Excel. Excel functions alphabetical. Excel functions by category. Changing cells 2. Result cell 1. Result cell If several people have specific information in separate workbooks that you want to use in scenarios, you can collect those workbooks and merge their scenarios.

Cells B1, B2, and B3 are the values for the loan amount, term length, and interest rate. Use Data Tables to see the effects of one or two variables on a formula. You can insert one or more custom variables in your formula by clicking the variable in the Variables tab. The below formula uses the variable Discounts to calculate the Discounted Prices.

Create a report using the Aggregate Formula in step 2. The report will show the values based on the default value defined in the Variable. All the Variables associated with the report will be listed in the Variables tab of the report designer.

Add the Variable as a User Filter in your report. This allows you to change the formula input and thus make a dynamic calculation. We've added the variable Discounts as a User Filter. In the below example, as you change the discount, the Discounted Price will be calculated accordingly.