ForecastByProduct
Generates forecasted opportunity data by given products.
Table Specific Information
Select
The add-in will use the Act! CRM API to process WHERE clause conditions built with the following column and operator.
- ProductId supports the '=' operator.
The add-in processes other filters client-side within the add-in. For example, the following queries are processed server side:
SELECT * FROM ForecastByProduct
Columns
| Name | Type | Description |
| CountPercent | Decimal | Count Percent |
| OppCount | Integer | Opp Count |
| ProductId | String | Product ID |
| ProductName | String | Product Name |
| TotalValue | Decimal | Total Value |
| TotalValuePercent | Decimal | Total Value Percent |
| WeightedValue | Decimal | Weighted Value |
| WeightedValuePercent | Decimal | Weighted Value Percent |