Skip to main content Join us at TDX in San Francisco or on Salesforce+ on March 5-6 for the Developer Conference for the AI Agent Era. Register now.

#Forecasting26 discussing

Hi there, 

I am trying to create a custom forecast type that shows quota against open pipeline that only consists of opportunities created in the current year. 

The picklist values for custom filter criteria do not include the opportunity created date - is there a way to add it? 

 

Thank you for any support 

2 answers
  1. Yesterday, 7:44 AM

    Thank you! 

    I had created a custom checkbox field for "Created This Year", unfortunately, it was not added to the custom filter picklist within the forecast object. 

     

    However, it worked with a custom number field and a flow that creates the current year in the field "Opportunity created year". 

     

    Thank you again, 

    Viola

0/9000

Hi, 

I wanted to add columns to the standard account forecasting . 

in the screenshot attached i want to add product code column. 

Could anyone please guide? 

Screenshot 2025-02-12 173122.png

 

@Forecasting

 

 

#Forecasting

1 answer
0/9000

Hello. I'm unsure how this could be tracked on a single opportunity record or if Salesforce is designed to do it differently. A salesperson determines an average invoice price for an opportunity, which would remain constant. However, they will project the amount of referrals we will receive from a client at that rate by a given month through the end of the year. They do this as a percentage of referrals per day (RPD).  

 

In the image provided, across the top row, they may project 0.05 RPDs for July, 0.06 RPDs for August, and so on. They will project this out while the opportunity is still at 50-80% and possibly enter these values all at the same time. How would something like this be captured on a single opportunity, or should this be done differently? Thank you. 

Screenshot 2025-02-11 at 2.19.40 PM.png

 

 

 

#Forecasting

1 answer
0/9000

Can I have 2 types of forecast categories based on record type? For example:    In a Sales record type, the following stage to forecast mapping is:  Open - Low Confidence  Discovery - Low Confidence  Demo- Low Confidence  Proposal Review - Likely  Contract Negotiations - Most Likely    But in a Renewal record type, I would want:  Open - Likely  Discovery - Likely  Proposal Review - Most Likely  Contract Negotiations - Most Likely   

2 answers
  1. Feb 10, 11:28 PM

    Thank you! 

     

    I've created 2 sales processes, however, they share similar stages.  

     

    I may have to create unique stages for each record type to achieve this.

0/9000

Hey everyone,

I'm hoping to get some advice.

We've been using advanced currency management at my company, but as many of you know,  it has some limitations when it comes to Forecast. 

 

We want to use Forecast with a custom measure this year, since our quotas are based on monthly recurring revenue (MRR), not TCV. I found out formula fields can't be used as a measure field in Forecast.

So, I created a currency field that pulls data from the MRR formula field using Flows. This lets me use MRR as a custom measure, but now I'm running into a currency issue. 

 

Advanced Currency Management only calculates MRR at the opportunity level, which doesn't work well with Forecast. This causes discrepancies between opportunity values and Forecast , making it hard to track quota attainment. 

 

As a workaround, I created a custom object called "Exchange Rate" with fields for each month of the year. Here's the formula we currently use for MRR: 

 

Revenue_Recurring_c / Months_In_Contract_c

(Revenue_Recurring_c is a rollup summary) 

 

I've tried a few different formulas, but none of them are working correctly. Here's the last one and that is closer to what I want to achieve (our corporate currency is NOT USD):

 

IF(TEXT(CurrencyIsoCode) = "USD - U.S. Dollar", CASE(MONTH(CloseDate), 1,(Revenue_Recurring_c * Exchange_Rate_r.January_c) / Months_In_Contract_c, 2,(Revenue_Recurring_c * Exchange_Rate_r.February_c) / Months_In_Contract_c, 3, (Revenue_Recurring_c * Exchange_Rate_r.March_c) / Months_In_Contract_c, 4,(Revenue_Recurring_c * Exchange_Rate_r.April_c) / Months_In_Contract_c, 5,(Revenue_Recurring_c * Exchange_Rate_r.May_c) / Months_In_Contract_c, 6,(Revenue_Recurring_c * Exchange_Rate_r.June_c) / Months_In_Contract_c, 7,(Revenue_Recurring_c * Exchange_Rate_r.July_c) / Months_In_Contract_c, 8,(Revenue_Recurring_c * Exchange_Rate_r.August_c) / Months_In_Contract_c, 9,(Revenue_Recurring_c * Exchange_Rate_r.September_c) / Months_In_Contract_c, 10,(Revenue_Recurring_c * Exchange_Rate_r.October_c) / Months_In_Contract_c, 11,(Revenue_Recurring_c * Exchange_Rate_r.November_c) / Months_In_Contract_c, 12,(Revenue_Recurring_c * Exchange_Rate_r.December_c) / Months_In_Contract_c, 0),Revenue_Recurring_c / Months_In_Contract_c)

This isn't working because it's not picking up the correct monthly exchange rate. I'm just getting the same result as the original MRR formula.

Does anyone know what I'm doing wrong? Or is there a Salesforce limitation that's preventing this from working? 

 

Ideally, I'd like the MRR calculation to be dynamic and update based on the close date. I think I might be able to do this with Flows, but first, I need to get this formula working correctly. 

 

Any advice would be greatly appreciated! 

 

Thanks 

 

 

#Forecasting

2 answers
  1. Feb 5, 4:20 PM

    Hey @Olajide Otolorin -Prince

    , thanks. 

     

    I already created the custom field to be used in Forecast. Using flows it pulls the numbers from the formula field. 

     

    The issue I'm facing now is related to currencies. There's a mismatch with the figures shown on the opportunity and on forecast. For instance: 

     

    This is what forecast show:

    Screenshot 2025-02-05 at 11.52.20 AM.png

     

    The numbers match for the opportunity in CAD (our corporate currency)

    Screenshot 2025-02-05 at 12.03.54 PM.png

     

    But for the opportunity in USD there is a mismatch. I'm guessing this is due the corporate currency rate.

    Screenshot 2025-02-05 at 12.02.47 PM.png

     

    Additionally, we are using advanced currency management but we need to disable it so we can use the custom metric in Forecast. As a workaround I created the custom object "Exchange Rate" so only USD opportunities are converted to CAD using the formula above. The formula is not working as if I change the close date on the opportunity, is not picking up the monthly rate from the Exchange Rate object. 

     

    Would you have any advice on that?  

     

    Thanks again! 

     

     

0/9000

 I need to find a direct way to export the details of opportunities associated with the forecast category displayed on the forecast screen, without having to create a report type and a report. Can you help me? Thank you very much.  

1 answer
  1. Mikey Brown (SETGO Partners) Forum Ambassador
    Jan 31, 2:36 PM

    Hi Juan, is this a one time thing? If so, you could use a tool like Data Loader to export the forecast data into a CSV. Otherwise, if you're looking for a custom export button, that would probably require custom code where you have a Lightning Component query the data to generate an export file that can be downloaded. 

0/9000

We are trying to get Forecasting to show Senior Management all-in company quotas and sales, but also the ability to drill down to individual quotas and sales.

 

SR MGMT:     Ra

SR MGMT:     Ku

SR MGMT:    Co

 

We want each of these people to see all-in sales quotas and sales, and that includes contributors below.  While each of these are Senior Management, they ALSO have quotas and create personal sales.

 

We will have two (and more) individuals with Contributor Quotas and Opportunity Sales:

 

Sales:  Ma

Sales:  Re

 

Example of what we'd like to see:  

Total Company Quota for Jan 2025:  $5million

Actual Company Sales for Jan 2025:   $4.4million

Projected Company Sales for Jan 2025:  $5.5million

 

Ku Quota for Jan 2025:  $1million

Ku Sales for Jan 2025:    $800,000

KU Projected for Jan 2025  $1.2million

 

Ma Quota for Jan 2025:  $500,000

Ma Sales fo rJan 2025:    $600,000

Ma Sales for Jan 2025:    $625,000

 

Etc.  

3 answers
  1. Jan 27, 2:13 PM

    UPDATE:   

     

    * Need to ensure USER roles and hierarchy in Setup is set appropriately BEFORE adjusting/assigning Forecast Hierarchy 

    * When that is set, then we were able to set forecast hierarchy.

0/9000

Projection question 

 

How has your experience been managing and designing projections for nonprofits? 

Projecting income/revenue/donations 

Projecting expense, attendance 

whatever the word projection means 

 

I appreciate any insights here  

 

#Nonprofit #Forecasting 

1 answer
  1. Jan 27, 10:00 AM

    Hi @Islam Ayoub   you can get some forecasts from Salesforce if you use Recurring Donations. Also reports like Not This Year But Last Year to see who gave last year but hasn't given yet. 

0/9000
3 answers
  1. Jan 25, 4:13 PM

    Hi @Jon Klingensmith To enable the ‘Territory’ hierarchy option when creating a new Forecast Type in Salesforce, you need to activate Enterprise Territory Management (ETM) in your organization. ETM allows forecasts to be based on your territory hierarchy instead of the default user role hierarchy.

    https://help.salesforce.com/s/articleView?id=sales.forecasts3_territory_forecasts_overview.htm&type=5

    Refer to the link:

    https://youtu.be/RxpPdOUwSjc?si=6WYeifAgiOizi92Y
0/9000

Hi,

 

I have set default company currency USD and user default currency is INR, after submission commit, best case , closed amount is converted into USD but showing as INR.

 

scenario: - 

on forecast page commit amount is showing 84000 INR , when it is submitted it is showing 1000 INR 

when we change the currency to USD it further converts it into USD 12 USD.

 

Ideally it should show us as 84000 INR on submission.

 

Please see, if anyone has faced this issue. 

 

forecasting error.jpg

 

Best Regards,

Raj

 

#Forecasting  @Forecasting

6 answers
  1. Jan 24, 5:21 PM

    Understood. I'm actively in conversation with engineering on this. Please keep the case open, it helps us make sure it is the same issue you are facing and to quantify the number of customers we have confirmed were impacted.

0/9000