Avg Discount % Per Bottle CP

🔢 Formula

m₁  ÷  m₂
with:
m₁ = Average([Depletions].[Original Price Per Unit])
    WHERE
        [Depletions].[Invoice Date] ≥ 'Start of Current Period'
        AND [Depletions].[Invoice Date] ≤ 'End of Current Period'
        AND [Depletions].[Has Sold Price] = true
        AND [Depletions].[Has Original Price] = true
m₂ = Average([Depletions].[Original Price Per Unit])
    WHERE
        [Depletions].[Invoice Date] ≥ 'Start of Current Period'
        AND [Depletions].[Invoice Date] ≤ 'End of Current Period'
        AND [Depletions].[Has Original Price] = true
        AND [Depletions].[Has Sold Price] = true

Output Format: ##0.0%;-##0.0%

Formula Last Updated: 2024-12-14T15:03:02Z

Avg Discount % Per Bottle PP

🔢 Formula

(m₁ - m₂)  ÷  m₃
with:
m₁ = Average([Depletions].[Original Price Per Unit])
    WHERE
        [Depletions].[Invoice Date] ≥ 'Start of Previous Period'
        AND [Depletions].[Invoice Date] ≤ 'End of Previous Period'
        AND [Depletions].[Has Original Price] = true
        AND [Depletions].[Has Sold Price] = true
m₂ = Average([Depletions].[Sold Price Per Unit])
    WHERE
        [Depletions].[Invoice Date] ≥ 'Start of Previous Period'
        AND [Depletions].[Invoice Date] ≤ 'End of Previous Period'
        AND [Depletions].[Has Sold Price] = true
        AND [Depletions].[Has Original Price] = true
m₃ = Average([Depletions].[Original Price Per Unit])
    WHERE
        [Depletions].[Invoice Date] ≥ 'Start of Previous Period'
        AND [Depletions].[Invoice Date] ≤ 'End of Previous Period'
        AND [Depletions].[Has Original Price] = true
        AND [Depletions].[Has Sold Price] = true

Output Format: ##0.0%;-##0.0%

Formula Last Updated: 2024-12-14T14:59:23Z

Avg Discount % Per Bottle Δ

🔢 Formula

((m₁ - m₂)  ÷  m₃)
with:
m₁ = Average([Depletions].[Original Price Per Unit])
    WHERE
        [Depletions].[Invoice Date] ≥ 'Start of Current Period'
        AND [Depletions].[Invoice Date] ≤ 'End of Current Period'
        AND [Depletions].[Has Original Price] = true
        AND [Depletions].[Has Sold Price] = true
m₂ = Average([Depletions].[Sold Price Per Unit])
    WHERE
        [Depletions].[Invoice Date] ≥ 'Start of Current Period'
        AND [Depletions].[Invoice Date] ≤ 'End of Current Period'
        AND [Depletions].[Has Sold Price] = true
        AND [Depletions].[Has Original Price] = true
m₃ = Average([Depletions].[Original Price Per Unit])
    WHERE
        [Depletions].[Invoice Date] ≥ 'Start of Current Period'
        AND [Depletions].[Invoice Date] ≤ 'End of Current Period'
        AND [Depletions].[Has Original Price] = true
        AND [Depletions].[Has Sold Price] = true