Measures - Sales Contract Line Analysis

This table shows the sales contract line fact time measures:

Measure	Mapping	Note
Agreed Quantity	tdsls301.qoor
Average Amount	Net Amount / Contract Count Distinct
Contract Count Distinct	Distinct count Sales Contract
Contract Line Count Distinct	Distinct count Sales Contract Line	(1)
Count	Always 1, but 0 for null records. Counts number of (partial) weeks for contract.
Customer Count Distinct	Distinct customer count
Discount Amount	Gross Amount – Net Amount
Discount Ratio	Discount Amount / Gross Amount
External Sales Rep Count Distinct	Distinct external sales rep count
Gross Amount	Agreed Quantity * Price. Calculated in LN, matching field in session tdsls3501m000.
Gross Price	Gross Amount / Ordered Quantity
Item Count Distinct	Distinct item count
Net Amount	Gross Amount – Discounts. Calculated in LN matching field in session tdsls3501m000
Net Amount Ratio	Net Amount / Gross Amount
Net Price	Net Amount / Ordered Quantity
Price	Gross Amount / Agreed Quantity (same as Gross Price)

• (1) Contract Line Analysis contains a record for each week. Contract Line Count Distinct can be used to count lines.