Effective discount
1 − actual price excl. VAT ÷ price before discounts; weighted by pre-discount revenue
- Formula
1 − actual price excl. VAT ÷ price before discounts; weighted by pre-discount revenue- Unit
- %
- Aggregation rule
- Weighted average
- Source system
- POS: receipts
- Owning role
- Category manager / merchandising analyst
- Frequency
- Weekly
Passport
- Grain
- SKU × day → category × week
- Numerator
- Discount amount excl. VAT: (price before discounts − actual price) × units
- Denominator
- Revenue before discounts excl. VAT
- At zero or no data
- Zero denominator or no data: show “—”, not 0.
- Limits
- The weight is revenue before discounts, not a simple average of item percentages. Card and promo-code discounts are included only if the method says so.
- Check example
- Price before discounts, RUB: 4000; Actual price, RUB: 3200; Units sold: 500.
(a-b)*c/(a*c)*100. Result: 20.0% - Related metrics
Version 1.0 · valid from 2026-11-16 · checked 2026-11-16
Related pages
- Term: Effective discount
- Calculation: Promo discount: the sales lift that makes it pay
Definition
The discount per piece a customer really gets under a mechanic such as “2 for 1” or “3 for 2”.
“2 for 1” is 50%, “3 for 2” is 33.3%, “second at 50% off” is 25%.