📋 Summary:
What it calculates: Calculates the ratio of total net sales (Quantity × Sold Price) to Average Order Value, excluding $0 orders, for completed orders with 'Paid', 'External', or 'Refunded' payment statuses within the current period. The denominator is derived by dividing total net sales by the count of unique orders (excluding refunded orders).
How to use it:
• Analyze the relationship between total sales and average order value
• Understand revenue performance relative to typical order size
• Identify potential shifts in customer purchasing behavior
Tip: Ensure the date picker is set to the precise time frame you want to analyze, and verify that zero-dollar orders are consistently excluded to maintain data integrity.
This summary was generated by AI.
📊 Quick Stats:
🏷️ Type: Calculated metric
📁 Build Beyond Limits Group: Σ Customer Net Sales vs Total AOV (Excl $0) CP
Customer Net Sales vs Total AOV (Excl $0) CP
🔢 Formula
m₁ ÷ (m₂ ÷ (m₃ - m₄))
with:
m₁ = Sum([Order Items].[Quantity] × [Order Items].[Sold Price])
WHERE
[Order Items].[Order Completed Date] ≥ 'Start of Current Period'
AND [Order Items].[Order Completed Date] ≤ 'End of Current Period'
AND [Order Items].[Order Status] = 'Completed'
AND [Order Items].[Payment Status] IN ('Paid', 'External', 'Refunded')
m₂ = Sum([Order Items].[Quantity] × [Order Items].[Sold Price])
WHERE
[Order Items].[Order Completed Date] ≥ 'Start of Current Period'
AND [Order Items].[Order Completed Date] ≤ 'End of Current Period'
AND [Orders].[Is 0 Dollar Order] = false
AND [Order Items].[Order Status] = 'Completed'
AND [Order Items].[Payment Status] IN ('Paid', 'External', 'Refunded')
m₃ = Distinct Count([Order Items].[Order Eid])
WHERE
[Order Items].[Order Status] = 'Completed'
AND [Order Items].[Payment Status] IN ('Paid', 'External')
AND [Order Items].[Order Completed Date] ≥ 'Start of Current Period'
AND [Order Items].[Order Completed Date] ≤ 'End of Current Period'
AND [Order Items].[Is 0 Dollar Order] = false
m₄ = Distinct Count([Order Items].[Order Eid])
WHERE
[Order Items].[Order Status] = 'Completed'
AND [Order Items].[Payment Status] = 'Refunded'
AND [Order Items].[Order Completed Date] ≥ 'Start of Current Period'
AND [Order Items].[Order Completed Date] ≤ 'End of Current Period'
AND [Order Items].[Is 0 Dollar Order] = false
Output Format: #,##0.0
Formula Last Updated: 2025-05-06T11:55:51Z
ℹ️ Additional Details
Key:
[calculation].[Customer Net Sales vs Total AOV (Excl $0) CP]ID:
016f4f5b-820b-4aea-a813-f7fc7a5f71c3
🏷️ Tags
Completed Date
Customer Net Sales vs Total AOV (Excl $0) CP
Is 0 Dollar Order
Net Sales
Order Eid
Order Status
Payment Status