This page provides summary of the Formula Expressions used in the .
Current Margin Rate
Definition
The weighted current gross margin percentage. Total margin divided by total revenue.
Formula
SUM(GrossMargin) / NULLIF(SUM(InvoicePrice),0)
Current Price
Definition
The average unit price in the current period. Sum of invoice price divided by sum of quantity.
Formula
SUM(InvoicePrice) / NULLIF(SUM(Quantity),0)
Current Cost Per Unit
Definition
The average unit cost in the current period. Per‑unit cost derived by dividing the cost by quantity.
Formula
SUM(InvoicePrice) / NULLIF(SUM(Quantity),0)
Previous Cost Per Unit
Definition
The average unit cost in the previous period. Per‑unit cost derived by dividing the cost by quantity.
Formula
SUM(TotalCosts) / NULLIF(SUM(Quantity),0)
Previous Margin Rate
Definition
The weighted gross margin percentage in the previous period. Previous total margin divided by previous total revenue.
Formula
SUM(GrossMargin) / NULLIF(SUM(InvoicePrice),0)
Previous Price
Definition
The average unit price in the previous period. Sum of invoice price divided by sum of quantity for previous period.
Formula
SUM(InvoicePrice) / NULLIF(SUM(Quantity),0)
Cost Change Abs
Definition
The period-over-period absolute change in average unit cost (current minus previous). Positive values indicate costs increased. Negative values indicate costs decreased.
Formula
s1.CurrentCostPerUnit - s2.PreviousCostPerUnit
-
s1 –
-
s2 –
Price Change Abs
Definition
The period-over-period absolute change in average unit price (current minus previous). Positive values indicate prices increased. Negative values indicate prices decreased.
Formula
s1.CurrentPrice - s2.PreviousPrice
Pass Through Ratio
Definition
The ratio of the period-over-period price change to the period-over-period cost change. It quantifies how effectively price movements reflect underlying cost movements between the previous period and the recent period.
Formula
if (
round(s1.CurrentCostPerUnit - s2.PreviousCostPerUnit,3) <= 0,
0,
(s1.CurrentPrice - s2.PreviousPrice) / ( s1.CurrentCostPerUnit - s2.PreviousCostPerUnit)
)
Margin Potential
Definition
The monetary amount of margin that could be recovered in the current period if the margin rate were restored to the previous period’s margin rate (apply previous margin % to current revenue). This expresses the theoretical margin uplift tied to correcting insufficient pass‑through.
Formula
if (
(s1.CurrentCostPerUnit - s2.PreviousCostPerUnit) - (s1.CurrentPrice - s2.PreviousPrice) <= 0,
0,
s1.CurrentQuantity * ( (s1.CurrentCostPerUnit - s2.PreviousCostPerUnit) - (s1.CurrentPrice - s2.PreviousPrice) )
)
Margin Delta (Percentage Points)
Definition
The period-over-period change in gross margin rate, expressed in percentage points (pp). Calculated as current margin rate minus previous margin rate. Positive values indicate margin rate improved, negative values indicate it declined.
Formula
s1.CurrentMarginRate - s2.PreviousMarginRate
Cost Delta
Definition
The period-over-period absolute change in average unit cost (current minus previous). Positive values indicate costs increased. Negative values indicate costs decreased.
Formula
s1.CurrentCostPerUnit - s2.PreviousCostPerUnit
Price Delta
Definition
The period-over-period absolute change in average unit price (current minus previous). Positive values indicate prices increased. Negative values indicate prices decreased.
Formula
s1.CurrentPrice - s2.PreviousPrice
Suggested Price
Definition
Calculates the sum of the current period’s average unit price and current period’s average unit cost, then subtracts the previous period’s average unit cost. This metric can be used to assess whether current pricing and cost changes are aligned with historical cost baselines.
Formula
s1.CurrentPrice + s1.CurrentCostPerUnit - s2.PreviousCostPerUnit
Revenue Uplift
Definition
Estimates the monetary impact resulting from the difference between the change in unit cost and the change in unit price between the current and previous periods. If the increase in cost per unit exceeds the increase in price per unit, the formula quantifies the total negative impact on margin for the current quantity sold. If the price increase matches or exceeds the cost increase, the impact is zero.
Formula
if (
(s1.CurrentCostPerUnit - s2.PreviousCostPerUnit) - (s1.CurrentPrice - s2.PreviousPrice) <= 0,
0,
s1.CurrentQuantity * ( (s1.CurrentCostPerUnit - s2.PreviousCostPerUnit) - (s1.CurrentPrice - s2.PreviousPrice) )
)