Report of the Week - What-If Analysis (Influence of Discount over Sales)

Report of the Week - What-If Analysis (Influence of Discount over Sales)

When an archer is aiming to hit the bullseye (or a sniper, her target), she has to consider external factors like gravity, wind direction and wind speed. Similarly, when running your business, you will have to ask various questions. Have you aligned yourself against all external factors, when it comes to meeting your target? Should you raise the price, or increase the production to make more money in the current market trend? By how much percentage? Is it the right time to run a marketing campaign?


Would it not be easier if you knew what the outcome can be when you undertake such a change? What-if Analysis helps you evaluate such options. It shows you how external changes might affect the outcome of a decision you are about to take.


What can be done?

What-if Analysis shows what might happen if one or more factors change. It lets you know the impact of various factors on your business and gives you an idea of what needs to be done.


Here are a few scenarios where What-if Analysis can help you.


  • You are planning for a sales day. Based on your previous sales, you can measure the impact of discount percent on your revenue and learn what percent of discount makes people buy more. And you can set your discount percentage to an optimal value so that it leads to maximum profit for you.

  • You have spent various amount on marketing over the months, which affects the leads gained in each month. With What-If analysis, you can learn what will happen if you increase or decrease the expenses.

  • You have multiple teams working on different projects. There will be different billing prices and hours per week, each team member might be working for.  You can check the time and money needed for each member - project combination and choose the best combination out of it to assign projects.

  • You have projected sales for the next six months. There is a possibility of your revenue increasing or decreasing and you can know with What-if analysis how much your revenue would be, based on percentage increase/decrease.

  • And much more...


Now, let's see how to implement the first example of measuring the impact of discount percentages on your revenue.



How to do What-if Analysis

You can easily set up a What-if report by following the steps here.


Step 1: Creating Variables


As we said earlier, What-if Analysis is to show the outcome when one or more parameter value changes. To parameterize dynamic inputs, you need to store all the possible values in a placeholder named Variable.

Here, we have created two variables to apply the change in discount percentage and sales volume. 


Discount Percentage

Create a variable with a range of discount percentages you are planning to provide. We have set the Range between 5 to 50 with an Increment Size of 5. And the Default Value is set as 10




If you plan to have different discounts for each product category, you need to create different variable for each category.



Sales Volume
Create a variable with a range of possible sales volume change. We have set the Range between -50 to +50 with an Increment Size of 5. And the Default Value is set as 0.



Step 2: Creating Aggregate Formulas


Construct an Aggregate Formula to compute your metrics. Insert the variables appropriately in the formula to visualize the impact as the dynamic value changes. You can specify different calculations for each value or a range of values.  

The following is the formula to calculate the sales after discount.

 

sum( "Sales"."Sales" )-(sum( "Sales"."Sales" )/ 100 )* ${Discount %} *(1+${Sales Volume}/100


If you have different product categories, then use the following formula to calculate the Sales after discount for all products with different discounts. 


Sum( "Sales"."Sales" )

-(sumif( "Sales"."Product Category" = 'Furniture' , "Sales"."Sales",   0 )/ 100 * ${Furniture Discount %} )

-(sumif( "Sales"."Product Category " = 'Stationery',   "Sales"."Sales",   0 )/ 100 * ${Stationery discount %} )

-(sumif( "Sales"."Product Category" = ' Grocery', "Sales"."Sales",   0 )/ 100 * ${Grocery Discount %}))*(1+${Sales Volume}/100 )


Step 3: Creating Report


Create the What-if report using the Aggregate Formula in Step 2.
  • X-Axis - Date with Month & Year
  • Y-Axis - Sales with Sum and Sales After Discount (Aggregate Formula with variable) with Actual



Report will be created as shown below. Sales after Discount will be calculated with a 10% discount based on the Variable's default value.



Apply Forecast for next one month to see the prediction for the upcoming month. 



Now, how do you dynamically change the input for the reports? We will see how it's to be done in the following step.

Step 4: Adding Variable as User Filter


Add the discount variables we had defined in Step 1 as User Filters in the report. Each User Filter will be in the form of a slider and will list the discount values in steps of 5. As you change the input (discount percentage) by moving each slider, the report will get re-generated dynamically based on the appropriate calculations defined in Step 2.



The final report will be as shown here. As you drag the What-If Variable sliders (the User Filters at the top), the total sales after discount will be calculated based on the values.


Now you have the privilege to know what might be the outcome of your sale month. And you are one step closer to a discount campaign run successfully!



    Access your files securely from anywhere









                          Zoho Developer Community





                                                • Desk Community Learning Series


                                                • Digest


                                                • Functions


                                                • Meetups


                                                • Kbase


                                                • Resources


                                                • Glossary


                                                • Desk Marketplace


                                                • MVP Corner


                                                • Word of the Day


                                                • Ask the Experts





                                                          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 Writer

                                                                                            Get Started. Write Away!

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

                                                                                              Zoho CRM コンテンツ




                                                                                                Nederlandse Hulpbronnen


                                                                                                    ご検討中の方




                                                                                                          • Recent Topics

                                                                                                          • Automating CRM backup storage?

                                                                                                            Hi there, We've recently set up automatic backups for our Zoho CRM account. We were hoping that the backup functionality would not require any manual work on our end, but it seems that we are always required to download the backups ourselves, store them,
                                                                                                          • Form / CRM Integration Not entering into workflow

                                                                                                            I have a simple form setup with company name, first name, last name and lead source. Each of the fields are mapped to CRM Leads module. When the form is submitted, the lead is populated properly. I also have a workflow created that when the lead source
                                                                                                          • Signature field is showing black

                                                                                                            Hello, When customer signed the service form, it is showing as below picture Phone model: iPhone 16 Pro We tried delete and install application, but it not solved. This has on phone of a few person. There is any advice to solve this?
                                                                                                          • Zoho Slowness - Workarounds

                                                                                                            Hi all, We've been having intermittent slowness and Zoho just asks for same stuff each time but never fix it. It usually just goes away on it's own after a couple weeks. Given that speed is a very important thing for companies to be able to keep up with
                                                                                                          • First day of trying FSM in the field.

                                                                                                            What we found. 1. with out a network connection we were unable to start a service call? 2. if you go to an appointment and then want to add an asset it does not seem possible. 3. disappointed not to be able to actually take a payment from within the app
                                                                                                          • In arattai received message can't be deleted

                                                                                                            The issue has been noticed in following: arattai app (Android) arattai app (Window) arattai web While the message posted by me may be deleted, the ones received from others can't be. The item <Delete> change to <Report> when the message is a received
                                                                                                          • Exclude Segment from Campaign Recipients

                                                                                                            I've created two Segments in order to separate Non-Marketing Contacts from Marketing Contacts. I'd like to send an Eblast to all Marketing contacts in my lists, but when I go to select Recipients, I have two options: 1. To Choose Lists to Send to; 2.
                                                                                                          • Don't understand why Forms Mobile Scan and Fill not working

                                                                                                            I have configure enabled mobile scan and fill, I have enabled QR and Bar code on two fields name and position, I have mapped seq 1 to Name and seq 2 to position, I have created a 2d QR code with the person names and position, seperated by a comma. When
                                                                                                          • Recurring Supervisor Rule Reminders for Open/In-Progress Tickets

                                                                                                            Hello Zoho Support Team, I would like to suggest a potential improvement regarding reminders for tickets and activities in Zoho Desk. Currently, it is possible to set reminders only once. In the Supervisor Rules section, it is possible to configure reminders
                                                                                                          • Syntax for URLs in HTML Snippets

                                                                                                            What are some best practices for inserting a URL in an HTML snippet? I've looked at Zoho Help articles on navigation-based and functional-based URLs, but I'm still unclear on how to incorporate them in an HTML snippet. For example, 1. How do I link to
                                                                                                          • Template usage

                                                                                                            Hi, We are using some templates as a response to customer questions. Is it possible to analyze the usage of these templates? We want to know if the use of our templates has increased over time
                                                                                                          • Round robin

                                                                                                            Hi, I'm trying to set up a round robin to automatically distribute tickets between agents in my team but only those tickets that are not otherwise distributed by other workflows or direct assignments. Is that possible and if so which criteria should I
                                                                                                          • Has anyone built a ticket export that allows Help Center users to export the tickets shown in the My Area list they are looking at?

                                                                                                            Hi, We are moving to Zoho Desk soon. Our current support system displays an option in our help center allowing customers to export their Open, Closed, or all tickets based on which list they are looking at. We need to offer the same in Zoho Desk help
                                                                                                          • How to mute chat notification sound by default in Zoho SalesIQ?

                                                                                                            We’ve recently embedded the Zoho SalesIQ chatbot on our website, and we’ve noticed that notification sounds sometimes play even when the visitor hasn’t interacted with the chat widget yet. We’re trying to understand two things: Why do these sounds occur
                                                                                                          • Ticket Status Colors

                                                                                                            Can i change the colors of Ticket Status in the admin panel? Or even change the background of the entire cell of a Critical ticket? This way its easy for my agents to see a urgent ticket when it comes in. Right now everything is black text. Here Right
                                                                                                          • Sync Lookup Fields from Zoho CRM

                                                                                                            HI Team, I have synced a lookup field from my CRM data to Campaigns. When I view the synced data the field appears to display a Zoho CRM record ID rather than the text value. Is it possible to get the sync to import the text value rather than the CRM
                                                                                                          • New From Address cannot verify

                                                                                                            I have created a new From Address, which is the support@ address for my domain, that forwards to the default support mailbox. Presumably then, the verification email that is sent, should turn up as a ticket, but it does not. How can I verify my from address so that I can use my own domain?
                                                                                                          • Introducing Assemblies and Kits in Zoho Inventory

                                                                                                            Hello customers, We’re excited to share a major revamp to Zoho Inventory that brings both clarity and flexibility to your inventory management experience! Presenting Assemblies and Kits We’re thrilled to introduce Assemblies and Kits, which replaces the
                                                                                                          • Closing Accounting Periods - Invoice/Posting dates

                                                                                                            Hi, I have seen in another thread but I'm unsure on how the 'transaction locking' works with regards to new and old transactions. When producing monthly accounts if I close December 24 accounts on 8th Jan 25 will transaction locking prevent me from posting
                                                                                                          • How to update/remove file in zoho creator widgets using javascript API

                                                                                                            Hi Team, I have developed a widget which allows inserting and updating records I have file upload field with multiple file upload. Now while doing insert form record, I am using uploadFile API to upload files for that record. I am using updateRecord API
                                                                                                          • Transitioning to API Credits in Zoho Desk

                                                                                                            At Zoho Desk, we’re always looking for ways to help keep your business operations running smoothly. This includes empowering teams that rely on APIs for essential integrations, functions and extensions. We’ve reimagined how API usage is measured to give
                                                                                                          • Sheet View in CRM portal

                                                                                                            Hi, When will it be possible for my CRM portal users to edit/add records with Sheet View? George
                                                                                                          • issue with image thumbnails not showing in Image Selector

                                                                                                            We have been using Zoho Campaigns for over a year, maybe close to two years, and this issue just started happening in the last month. I wanted to wait to see if it would resolve on it's own, and it doesn't seem to be. The thumbnail images for all new
                                                                                                          • Deluge Script for adding tag

                                                                                                            Trying to create a custom function where a tag is added to a record - but for the life of me, I cannot figure out how. Help please! Moderation Update: Adding the help doc and sample to add Tags to records via deluge here for everyone's benefit. tag1 =
                                                                                                          • Unlock your Zoho Vault with OneAuth, Windows Hello, TouchID, YubiKey, and many more!

                                                                                                            Hello everyone, We are thrilled to introduce one of the most highly requested features – the ability to unlock your Zoho Vault using various authenticators. The primary purpose of a password manager is to remember just one master password and securely
                                                                                                          • Where does this report come from in the Zoho One ecosystems?

                                                                                                            Is this directly from MA, Analytics or ??? ???
                                                                                                          • How to Delete/hide Google adwords section from Layout?

                                                                                                            Hi people, maybe someone can tell me how to remove or hide the Google adwords section from my layout? Im not using it and it takes too much space.
                                                                                                          • All new Address Field in Zoho CRM: maintain structured and accurate address inputs

                                                                                                            The address field will be available exclusively for IN DC users. We'll keep you updated on the DC-specific rollout soon. It's currently available for all new sign-ups and for existing Zoho CRM orgs which are in the Professional edition. Managing addresses
                                                                                                          • Blueprint or Validation Rules for Invoices in Zoho Books

                                                                                                            Can I implement Blueprint or Validation Rules for Invoices in Zoho Books? Example, use case could be, Agent confirms from client that payment is done, but bank only syncs transactions tomorrow. in this case, Agent can update invoice status to done, and
                                                                                                          • Creator roadmap for the rest of 2022

                                                                                                            Hi everyone, Hope you're all good! Thanks for continuing to make this community engaging and informative. Today we'd like to share with you our plans for the near future of Creator. We always strive to strike a good balance of features and enhancements
                                                                                                          • How can I get base64 string from filecontent in widget

                                                                                                            Hi, I have a react js widget which has the signature pad. Now, I am saving the signature in signature field in zoho creator form. If I open the edit report record in widget then I want to display the Signature back in signature field. I am using readFile
                                                                                                          • Default Value on a Number

                                                                                                            Hi, I would be nice to also be able to set the Default Value for a Number Field, not just the Initial Value shown, so if not on the screen so not enetred it can have a value of 0 for example. Thanks Dan
                                                                                                          • Add Setting Values to the Rules

                                                                                                            Hi, It would be great to use the rules to set values in fields for submission, such as if a Type is X then set the Field Y to 10. Thanks Dan
                                                                                                          • So we ran with it for the week

                                                                                                            In our company i bit the bullet and ran with FSM for a whole week. Service calls, deliveries and surveys. Covering about 30-120 miles a day to domestic properties. Loved the appointment list and satnav integration. Loved the timer to measure the appointments.
                                                                                                          • Organization Emails in Email History

                                                                                                            How can I make received Org Emails to show up here?
                                                                                                          • Is there a way to set Document Owner/Sender via the API

                                                                                                            When sending requests for zoho sign, it would seem zoho uses the id of the person that created the zoho api cred to determine the owner_id, is there a way to set a default for this?
                                                                                                          • What's New - September 2025 | Zoho Backstage

                                                                                                            September has been a different month for Zoho Backstage. Instead of rolling out a long list of new features, we focused on something just as important: Performance, reliability, and stability The event season is in full swing, and organizers are running
                                                                                                          • Prevent stripping of custom CSS when creating an email template?

                                                                                                            Anyone have a workaround for this? Zoho really needs to hire new designers - templates are terrible. A custom template has been created, but every time we try to use it, it strips out all the CSS from the head.  IE, we'll define the styles right in the <head> (simple example below) and everything gets stripped (initially, it saves fine, but when you browse away and come back to the template, all the custom css is removed). <style type="text/css"> .footerContent a{display:block !important;} </style>
                                                                                                          • link to any Belgian bookkeeping software?

                                                                                                            Hello, Does anyone on this Forum can help me with the question whether the ZOHO CRM (Invoices) or ZOHO Book can be linked to software that is used for Belgian Bookkeeping/accountancy? By linking, I mean either with the help of a middleware program or either by the ability to export the custom made reports as CSV-files... If someone has an experience with online CRM-Accountancy in Belgium, with ZOHO (or other), it would be great to read it... Thank you
                                                                                                          • marketing automation

                                                                                                            wants to know about the zoho marketing automation
                                                                                                          • Next Page