Discounts lost in 2025

Suppliers in DimSupplier with an EarlyPaymentDiscountPct allow it when paid within DiscountDays of the InvoiceDate. For their invoices paid in 2025 (paid time), what discount was lost by paying later (Amount x EarlyPaymentDiscountPct / 100), in USD?

Expected: One amount in USD, 2 decimals · KPI card
Tables: FactInvoiceEvent, FactInvoice, DimSupplier · columns

FactInvoiceEvent
FactInvoice
DimSupplier

EarlyPaymentDiscountPct
DiscountDays
InvoiceDate
Amount
Topics: Cash Flow 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