📊 Quick Stats:
🏷️ Type: Calculated metric
📁 Build Beyond Limits Group: Σ 9L Cases %
9L Cases % CP
🔢 Formula
m₁ ÷ m₂
with:
m₁ = Sum([Depletions].[Cases 9L Sold])
WHERE
[Depletions].[Invoice Date] ≥ 'Start of Current Period'
AND [Depletions].[Invoice Date] ≤ 'End of Current Period'
AND [Outlets].[Outlet Premise Type] ≠ 'DTC'
m₂ = Sum([Depletions].[Cases 9L Sold])
WHERE
[Depletions].[Invoice Date] ≥ 'Start of Current Period'
AND [Depletions].[Invoice Date] ≤ 'End of Current Period'
AND [Outlets].[Outlet Premise Type] ≠ 'DTC'
Output Format: #,##0.00
Formula Last Updated: 2025-11-08T16:17:29Z
ℹ️ Additional Details
Key:
[calculation].[9L Cases % CP]ID:
08e9cbc0-5cb9-43f5-8b16-b4cc68306ef1
🏷️ Tags
9L Cases % CP
Cases 9L Sold
Invoice Date
Outlet Premise Type