Skip to main content
DD-GLT-001 Mizan Retail: Sales Up, Profit Down — Journals, Trial Balance and Budget Get the data →
DD-GLT-001-Q030 Very Hard Time series

Gross profit bridge: the margin effect

Split the change in gross profit from 2024 to 2025 into a volume effect, (revenue 2025 - revenue 2024) x gross margin 2024, and a margin effect, (gross margin 2025 - gross margin 2024) x revenue 2025. What is the margin effect, in USD (negative if the margin fell)?
Expected
One amount in USD, 2 decimals · Waterfall chart
Tables
FactJournalLines, DimAccount, DimDate · columns
  • FactJournalLines
  • DimAccount
  • DimDate
  • JournalID
  • AccountCode
  • Debit
  • Credit
  • PeriodKey
  • ReportingLineCode

Discussion

No one has posted here yet. Ask something, compare your result, or share how you solved it.

A free account takes a minute. Your draft is kept while you sign in. Need help? Message us

Create a free account Sign in