Purpose
This measure quantifies the portion of revenue generated from transactions with negative margin. It helps business users understand the financial exposure associated with selling below cost and supports margin protection and corrective pricing actions.
Business Context
Negative Margin Revenue Share highlights how much of the business is impacted by unprofitable transactions. By expressing this exposure as a percentage of total revenue, the measure enables consistent monitoring across segments, time periods, and organizational levels.
Definition
The measure calculates the share of total revenue associated with negative margin transactions over the Agent’s filtered scope.
Business Formula
Negative Margin Revenue Share (%) = Sum of Revenue Where Margin < 0 / Total Revenue
Agent Expression
SUM(IF(GrossMargin < 0, Revenue, 0)) / NULLIF(SUM(Revenue), 0)