I have forecasts setup and we are grouping the forecast quotas by Division. I am trying to create a report on quotas vs actuals. I have set up the Custom Report Type as Forecast Quota with or without Forecast Items because I want to capture all the quotas, not just those that have opportunities associated. The issue is that the group is not showing on the Forecast Quota, only on the Forecast item. This means that those Quotas that do not have any associated Opportunities I lose the Division (grouping). I find this strange because when I query the Forecast Quota object, there is a field for ForecastingGroupItemId and with that I can get the label and therefore the division.
So why can I get this through SOQL but not in a report? The Forecasting Group Item does not even appear on the report type. Any ideas how I can get this?
Hi, sorry for the inconvenience. If you don't receive a response here, we recommend reaching out to our support team for further assistance. You can do so by visiting https://help.salesforce.com/s/articleView?id=000393090&language=en_US&type=1
