Glossary (CPQ Dashboard)

Invoice Price

= ∑ (Invoice Price.Quote Line Id * Quantity)

Margin

= ∑ (Invoice Price.QuoteLineId * Quantity) - ∑ (Cost.QuoteLineId * Quantity)
If Cost of Quote Line Id is null, it is skipped and not calculated.

Discount

If List Price > Invoice Price, 
= ∑ (List Price.QuoteLineId * Quantity) -  ∑ (Invoice Price.QuoteLineId * Quantity), else return 0

Average Approved/Denied Time Velocity Per Month/Quarter

Average Deal Time Velocity Per Month/Quarter

Approved

= Approved + No Approval Required

Discount %

= Total Discount / List Price