Skip to main content
DD-PRC-003 Mizan Group: From Requisition to Payment, and the Fuel Cards — Procurement & Spend Get the data →
DD-PRC-003-Q017 Medium Time series

Fresh-food price exceptions in June 2025

An invoice line is a price exception when its InvoiceUnitPrice is more than 2% above the matched PO line's POUnitPrice. How many Retail invoice lines for fresh produce, meat and poultry, and dairy and eggs (items R01-*, R02-*, R03-*) dated June 2025 are price exceptions?
Expected
One whole number · KPI card
Tables
FactInvoiceLine, FactPOLine · columns
  • FactInvoiceLine
  • FactPOLine
  • ItemCode
  • InvoiceUnitPrice
  • POUnitPrice
  • 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