Skip to main content
DD-PRC-001 Mizan Manufacturing: Orders, Deliveries and Invoices — Procurement & Spend Get the data →
DD-PRC-001-Q028 Hard Time series

What the resin price rise cost

Price variance on an invoice line = InvoiceQty x (InvoiceUnitPrice - the PO line's POUnitPrice). What was the total price variance on Resins and polymers (items M01-*) invoiced from July 2024 to March 2025, in USD?
Expected
One amount in USD, 2 decimals · KPI card
Tables
FactInvoiceLine, FactPOLine, DimItem · columns
  • FactInvoiceLine
  • FactPOLine
  • DimItem
  • InvoiceQty
  • InvoiceUnitPrice
  • POUnitPrice
  • POLineID
  • InvoiceDate

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