High Buyback Customers Agent (Formula Expressions)

This page provides summary of the Formula Expressions used in the High Buyback Customers Agent (Definition).

Return %

Definition

:question_mark:

Percentage of returned or buyback quantity relative to total positive sold quantity for a given customer or aggregation level. This shows how much of the shipped volume is coming back as returns or buybacks.

Formula

SUM(IF(Quantity < 0, -Quantity, 0)) / NULLIF(SUM(IF(Quantity > 0, Quantity, 0)), 0)

Potential Revenue

Definition

:question_mark:

Estimated revenue impact of returns and buybacks, based on the negative invoice values of returned transactions. The metric uses 10% of the returned invoice price as a proxy for revenue at risk or recoverable revenue.

Formula

SUM(IF(Quantity < 0, -InvoicePrice, 0)) * 0.1

Potential Profit

Definition

:question_mark:

Estimated profit impact of returns and buybacks, based on the negative gross margin of returned transactions. The metric uses 10% of the returned gross margin as a proxy for profit at risk or potential profit recovery.

Formula

SUM(IF(Quantity < 0, -GrossMargin, 0)) * 0.1