Implementing What-If Scenario

What-If Formulas allow you to analyze and explore different scenarios using formulas (expressions) based on measures and fixed values. It leverages the goal-seeking method to suggest the best input values based on desired outcomes. Refine your analysis by focusing on specific subsets of data and applying dimension filters, which can help you gain deeper insights and make more targeted decisions.

Guide to Setting Up What-If Formulas: A Step-by-Step Process

The What-If Formula enables you to experiment with different scenarios by defining what-if expressions based on the scenario. Apply filters to the dimensions available in the Datasource to narrow down the data used in the calculation, allowing for more precise and targeted analysis. Follow the below steps to get started:

1. To define a what if formula, navigate to the What If Formula under the Analysis module.
2. To create a new formula, click on New Formula. You will be redirected to the What If formula editor.

3. Start with a formula name. Let us name it “Product Pricing Analysis.”.
4. Select from Datasources or Query to start with the formula. Let us select the Datasource option for defining the formulas.
5. Select the “Sales” Datasource from the list of Datasources available within Infoveave.
6. Click on Save option to start defining the measure variables for the formula.
   • The formula will be added to the What If Formula under the Analysis module.

7. To start defining the variables, click on the Edit option associated with the formula.

8. You will now be directed to define the measures, expressions, and fixed values for the scenario analysis.

9. Click on the Measures icon to start assigning the selected measures with a distinct key for easy reference and identification, which will help you formulate the scenario.

10. Select the key variable for the required measures. Let us define the key variable as “a”.

11. Assign a name to the selected key and measure the value. Let us name the key variable “Factory Price”.

12. Select the required measure from the selected Datasource. Let us select “Factory Price as the measure.

13. Select all the required dimensions associated with the measure that are required for the analysis. The required dimensions include “Order Priority”, “Sales Channel”, “Country”, “Category”, “Product Type”, and “Order Date”.

    • Let us keep the value type as value.

14. Click on the Save option, to add the measure value.

15. Define all the key variables required for the analysis in the same manner. Let us keep the same dimension across all variables.
16. Once all the key variables are defined, let us start defining the expression or formula.
17. Click on the Expression icon to start defining the required expressions/formulas.

18. Select the key variable for the required measures. Let us define the key variable as “d”.

19. Assign a name to the selected key and measure the value. Let us name the key variable “Transit Insurance Amount”.

20. Define the formula using the key variables defined. Let us define the formula as d=c(a+b).*

    • Where a=Factory Price, b=Shipping Cost, and c=Transit Insurance Percentage

21. Click on the Save option, to add the expression.
22. Define all the required expression for the analysis in the same manner.
23. As you finish defining all the required measures and expressions, navigate back to the What If Formula under the Analysis module.

24. You have now successfully defined the what if formula in Infoveave.

Note: Let us define the key variable and define the expression as below:

Key	Name	Type	Value	Expression
a	Factory Price	Measure
b	Shipping Cost	Measure
c	Transit Insurance Percentage	Measure
d	Transit Insurance Amount	Expression		c*(a+b)
e	GST Percentage	Measure
f	GST Value	Expression		e*(a+b+d)
g	Landing Price	Expression		a+b+d+f
h	Handling Charge	Measure
i	GST Offset	Expression		-(f)
j	Dealer Margin Percentage	Measure
k	Dealer Margin Value	Expression		IF(n=0,jm,j(n+m))
l	Dealer Margin Total	Expression		k+o
m	Market Price	Expression		g+h+i+l
n	MP Offset Impacts DM	Value	0
o	DM Adjustment Amount	Expression		IF( n=0,0,(m+n)-i-k-h-g)

Conclusion

What-If Formulas in Infoveave offer a powerful method for analyzing and exploring different scenarios. By leveraging formulas based on measures and fixed values, you can refine your analysis and gain deeper insights. The step-by-step guide provided outlines how to set up What-If Formulas, for the scenarios and make more informed decisions based on desired outcomes.