SF - Opportunity Line Item
This table describes the Opportunity Revenue Line metrics.
These metrics are used in the Document Currency (DC) and Corporate Currency (CC) fact folder in this subject area. Document Currency is the currency used while entering the data in the application. Corporate Currency is the currency defined in Salesforce CRM. Metrics in these folders show amounts in their respective currencies.
| Metric | Metric Definition |
|---|---|
| # of Closed Opportunity Line Items | The total number of Opportunity Li.ne Items for Closed Opportunities ( SF Opportunity Is Closed = True ) |
| # of Lost Opportunity Line Items | The total number of Opportunity Line Items for Lost Opportunities ( SF Opportunity Is Won = False, SF Opportunity Is Closed = True ) |
| # of Open Opportunity Line Items | The total number of Opportunity Line Items for Open Opportunities ( SF Opportunity Is Closed = False ) |
| # of Opportunity Line Items | The total number of Opportunity Line Items |
| # of Raw Opportunity Line Items | The total number of Opportunity Line Items including the deleted Line Items |
| # of Won Opportunity Line Items | The total number of Opportunity Line Items for Won Opportunities ( SF Opportunity Is Won = True ) |
| Average Days Until Schedule Date | The average number of days until the Scheduled date. This is calculated as follows: When the Current date is < Schedule date then ( Schedule date - current date in days ) else null |
| Closed Line Item Amount | The total Line Item Amount on the Closed Opportunity Line Item |
| Closed Line Item Split Amount | The total Line Item Split Amount on the Closed Opportunity Line Item |
| Expected Line Item Amount | The Expected Line Item Amount (This metric is calculated as Line Item Amount * Probability % / 100 ) |
| Expected Line Item Schedule Amount | The total expected Line Item Schedule Amount |
| Expected Line Item Split Amount | The expected Line Item Split Amount Note: This would count splits across split types e.g. Revenue, Overlay etc. |
| Line Item Amount | The total Amount on the Opportunity Line Item |
| Line Item Schedule Amount | The total Line Item Schedule Amount |
| Line Item Split Amount | The total Line Item Split Amount. Note: This would count splits across split types e.g. Revenue, Overlay etc. |
| Lost Line Item Amount | The total Line Item Amount on the Lost Opportunity Line Item |
| Lost Line Item Split Amount | The total Line Item Split Amount on the Lost Opportunity Line Item |
| Open Line Item Amount | The total Line Item Amount on the Open Opportunity Line Item |
| Open Line Item Split Amount | The total Line Item Split Amount on the Open Opportunity Line Item |
| Opportunity Amount | The total Opportunity (header) Amount |
| Opportunity Line Item Discount (%) | The total Line Item Discount on the Opportunity Line Item |
| Raw Line Item Amount | The total Amount on the Opportunity Line Item including the deleted Line Items |
| Won Line Item Amount | The total Line Item Amount on the Won Opportunity Line Item |
| Won Line Item Split Amount | The total Line Item Split Amount on the Won Opportunity Line Item |