Forum Discussion

jkulyk's avatar
jkulyk
Regular Visitor
2 years ago

Financial Forecasting

Hi 🙂 

I would like to build a simple financial forecasting model based on "price" and "quantity" for the rest of 2024.

The "actuals"  coming in to my model each month from SQL database. 

Now, I have a matrix with the actual data "price","quantity" and "Sales" for each month and want to calculate the sales for the rest of the year based on the parameters price&quantity. (need to change the parameters on the front end to see how the sales will develop)

 

Does anyone has an advice for building this in a clear structured way? (or tips for visuals)

 

Best Regrads 

Johannes

Need Help
Tips and Tricks

8 Replies

    • jkulyk's avatar
      jkulyk
      Regular Visitor
      2 years ago

      yes, i tried the what if parameters. But its not really working..

      Do you mean to build a table like this?

       

      • MFelix's avatar
        MFelix
        Super User
        2 years ago

        Hi jkulyk,

         

        The option is to create those what if parameters and the have a calculated measure to pick up the values.

         

        Can you please give an example of what you want to achieve and the setup of your model. that will help to give you a more appropiate answer.