Discounts left on the table, 2025

Some suppliers give EarlyPaymentDiscountPct off if paid within DiscountDays of the invoice date. For invoices dated 2025 from those suppliers, how much discount was lost by paying later than DiscountDays (PaidDate - InvoiceDate)? USD, 2 decimals.

Expected: One amount in USD, 2 decimals · KPI card
Tables: FactInvoiceLine, DimSupplier, DimDate · columns

FactInvoiceLine
DimSupplier
DimDate

EarlyPaymentDiscountPct
DiscountDays
PaidDate
InvoiceDate
LineAmount
Topics: Cash Flow Time Series & Trends Supplier Performance

Discussion

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

Join the discussion

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

Create a free account Sign in