Period Over Period Dashboard - Fields Definition

Owned by Jana Volencová (Deactivated)
Dec 21, 2023
1 min read

Ratio Types and formulas used (by default) to calculate the output measure:

  • Gross Margin % = Gross Margin / Invoice Price

  • Price Leakage % = (Local List Price – Net Price) / Local List Price

  • Price Realization % = Invoice Price / Global List Price

  • Incentive % = Net Sales Column / Local List Price Column

  • Average Price Per Unit = Invoice Price / Quantity

  • Average Profit Per Unit = Gross Margin / Quantity

  • Custom = input values are provided manually as numerator and denominator in the formula

Actual Period

  • Start: (Final Interval) – ((Number Of Intervals) * Interval Size)

  • End: calendar unit defined by Final Interval

Comparison Period

  • Start: (Final Interval – Offset of Comparison Period) – ((Number Of Intervals) * Interval Size)

  • End: calendar unit defined by (Final Interval – Offset of Comparison Period)