PODs CP
Formula
m₁ / m₂
with:
m₁ = Distinct Count([Depletions].[Aggregate Item Name])
WHERE
[Depletions].[Invoice Date] ≥ 'Start of Current Period'
AND [Depletions].[Invoice Date] ≤ 'End of Current Period'
AND [Depletions].[Is Sample Order] = false
AND [Outlets].[Outlet Premise Type] ≠ 'DTC'
m₂ = Distinct Count([Depletions].[Outlet Eid])
WHERE
[Depletions].[Invoice Date] ≥ 'Start of Current Period'
AND [Depletions].[Invoice Date] ≤ 'End of Current Period'
AND [Depletions].[Is Sample Order] = false
AND [Outlets].[Outlet Premise Type] ≠ 'DTC'
Additional Details
Output Format: #,##0
Created: 2024-10-26T17:52:09Z
Last Updated: 2024-11-14T18:55:01Z
Key:
[calculation].[PODs CP]
Tags
Aggregate Item Name
Invoice Date
Is Sample Order
Outlet Eid
Outlet Premise Type
PODs CP
PODs PP
PODs Δ
PODs Δ%
PODs PP
Formula
m₁ / m₂
with:
m₁ = Distinct Count([Depletions].[Aggregate Item Name])
WHERE
[Depletions].[Invoice Date] ≥ 'Start of Previous Period'
AND [Depletions].[Invoice Date] ≤ 'End of Previous Period'
AND [Depletions].[Is Sample Order] = false
AND [Outlets].[Outlet Premise Type] ≠ 'DTC'
m₂ = Distinct Count([Depletions].[Outlet Eid])
WHERE
[Depletions].[Invoice Date] ≥ 'Start of Previous Period'
AND [Depletions].[Invoice Date] ≤ 'End of Previous Period'
AND [Outlets].[Outlet Premise Type] ≠ 'DTC'
PODs Δ
Formula
(m₁ / m₂) - (m₃ / m₄)
with:
m₁ = Distinct Count([Depletions].[Aggregate Item Name])
WHERE
[Depletions].[Invoice Date] ≥ 'Start of Current Period'
AND [Depletions].[Invoice Date] ≤ 'End of Current Period'
AND [Depletions].[Is Sample Order] = false
AND [Outlets].[Outlet Premise Type] ≠ 'DTC'
m₂ = Distinct Count([Depletions].[Outlet Eid])
WHERE
[Depletions].[Invoice Date] ≥ 'Start of Current Period'
AND [Depletions].[Invoice Date] ≤ 'End of Current Period'
AND [Depletions].[Is Sample Order] = false
AND [Outlets].[Outlet Premise Type] ≠ 'DTC'
m₃ = Distinct Count([Depletions].[Aggregate Item Name])
WHERE
[Depletions].[Invoice Date] ≥ 'Start of Previous Period'
AND [Depletions].[Invoice Date] ≤ 'End of Previous Period'
AND [Depletions].[Is Sample Order] = false
AND [Outlets].[Outlet Premise Type] ≠ 'DTC'
m₄ = Distinct Count([Depletions].[Outlet Eid])
WHERE
[Depletions].[Invoice Date] ≥ 'Start of Previous Period'
AND [Depletions].[Invoice Date] ≤ 'End of Previous Period'
AND [Depletions].[Is Sample Order] = false
AND [Outlets].[Outlet Premise Type] ≠ 'DTC'
PODs Δ%
Formula
(m₁ / m₂) / (m₃ / m₄) - 1
with:
m₁ = Distinct Count([Depletions].[Aggregate Item Name])
WHERE
[Depletions].[Invoice Date] ≥ 'Start of Current Period'
AND [Depletions].[Invoice Date] ≤ 'End of Current Period'
AND [Depletions].[Is Sample Order] = false
m₂ = Distinct Count([Depletions].[Outlet Eid])
WHERE
[Depletions].[Invoice Date] ≥ 'Start of Current Period'
AND [Depletions].[Invoice Date] ≤ 'End of Current Period'
AND [Depletions].[Is Sample Order] = false
m₃ = Distinct Count([Depletions].[Aggregate Item Name])
WHERE
[Depletions].[Invoice Date] ≥ 'Start of Previous Period'
AND [Depletions].[Invoice Date] ≤ 'End of Previous Period'
AND [Depletions].[Is Sample Order] = false
m₄ = Distinct Count([Depletions].[Outlet Eid])
WHERE
[Depletions].[Invoice Date] ≥ 'Start of Previous Period'
AND [Depletions].[Invoice Date] ≤ 'End of Previous Period'
AND [Depletions].[Is Sample Order] = false