Tip of the Week: Forecasting with what-if analysis

Tip of the Week: Forecasting with what-if analysis

You make challenging decisions in your business everyday. These decisions, good or bad, determine the future of your business. Good decision-making often involves guess work—you guess the outcome of your actions against various external factors. Wouldn't it be easier if you had the answers before you started making changes? 


Forecasting, along with what-if analysis, helps you evaluate information and predict what might happen in the future against the changing factors. 

Set up what-if analysis with forecasting

Follow the steps here to set up a what-if analysis with forecasting.

  1. Follow the steps here to set up what-if analysis in a chart. Refer to What-If Solutions here.
  2. Set up forecasting in this chart. By default, what-if will be applied over the entire chart, including forecasted data. 


  3. Now, you can choose to apply what-if analysis over the forecasted data alone by selecting the Treat as What-if Forecasting checkbox. 


The following screen illustrates what-if analysis for forecasting data alone. 


That's it. Your forecasting with what-If analysis is now ready, and it can help you take informed business decisions. 


Stay tuned. We'll be back with the next useful tip on business analytics soon!


    Access your files securely from anywhere

        All-in-one knowledge management and training platform for your employees and customers.







                              Zoho Developer Community




                                                    • Desk Community Learning Series


                                                    • Digest


                                                    • Functions


                                                    • Meetups


                                                    • Kbase


                                                    • Resources


                                                    • Glossary


                                                    • Desk Marketplace


                                                    • MVP Corner


                                                    • Word of the Day


                                                    • Ask the Experts



                                                              • Sticky Posts

                                                              • Tip of the Week - Spot Risky Sales with Conditional Formatting

                                                                In Zoho Analytics, small tweaks can lead to big insights. One such feature is Conditional formatting based on other columns, your key to instantly spotting where sales success is overshadowed by product returns. Our tip this week shows you how to apply


                                                              Manage your brands on social media



                                                                    Zoho TeamInbox Resources



                                                                        Zoho CRM Plus Resources

                                                                          Zoho Books Resources


                                                                            Zoho Subscriptions Resources

                                                                              Zoho Projects Resources


                                                                                Zoho Sprints Resources


                                                                                  Qntrl Resources


                                                                                    Zoho Creator Resources



                                                                                        Zoho CRM Resources

                                                                                        • CRM Community Learning Series

                                                                                          CRM Community Learning Series


                                                                                        • Kaizen

                                                                                          Kaizen

                                                                                        • Functions

                                                                                          Functions

                                                                                        • Meetups

                                                                                          Meetups

                                                                                        • Kbase

                                                                                          Kbase

                                                                                        • Resources

                                                                                          Resources

                                                                                        • Digest

                                                                                          Digest

                                                                                        • CRM Marketplace

                                                                                          CRM Marketplace

                                                                                        • MVP Corner

                                                                                          MVP Corner









                                                                                            Design. Discuss. Deliver.

                                                                                            Create visually engaging stories with Zoho Show.

                                                                                            Get Started Now


                                                                                              Zoho Show Resources

                                                                                                Zoho Writer

                                                                                                Get Started. Write Away!

                                                                                                Writer is a powerful online word processor, designed for collaborative work.

                                                                                                  Zoho CRM コンテンツ




                                                                                                    Nederlandse Hulpbronnen


                                                                                                        ご検討中の方