How do I Calculate Weighted Probability in the Opportunities App?

Updated on September 25, 2018 07:03AM by Admin

In Apptivo, each opportunity you create will have the Amount and Probability field that represents the win/loss percent of that particular opportunity. This post will now show you how to calculate the weighted probability of an opportunity. In general, a weighted probability is a kind of average. This weighted probability is used to forecast the revenue amount generation and allocates a value to each deal in view of where it is in the business pipeline. It is crucial in generating sales forecasting reports

In our case, the weighted probability is based on the opportunities’ probability value and total amount.

Probability (%) * Total Amount = Weighted Probability
 

Steps to calculate Weighted Probability

  1. The first step is to log in to your Apptivo account and access the Opportunities App.
  2. Click on Settings > Customize App > Master Layout.
    opportunity master layout

  3. To perform the calculation, we are going to use the Function attribute. So drag and drop the Function attribute from the Palette.
    drag and drop function attribute

  4. Click on the Function field. This will open up the Inspector tab in the right pane where the field can be renamed.
    rename function attribute

  5. The next step is to define the formula. To do so, scroll down to the last and click on Create Function button.
    click create function button in opp

  6. This will open up the Function Editor popup. Create a formula that multiplies the probability and amount by selecting the required attributes from the Insert Attributes dropdown. The formula will be represented as shown in the image below:
    create function editor in opp

  7. Click on Create.
  8. And ensure to Save the changes in the master layout.
  9. Now, create a new opportunity or open an existing one, and you will find the weighted probability value calculated as below:
    view weighted probability calculated

Now that the weighted probability function is created, we will need to add that field to the List Layout of the Opportunities, so that this can be viewed in the reports generated. To do this, access the list layouts by navigating to the Settings > Customize App > List Layouts > Web. From here, we can add the Weighted Probability Value to the required layout. Changes made will be auto-saved.

add weighted probability to opp reports

The added fields will be displayed in the reports, as shown in the image below:

view weighted probability in opp reports