Skip to main content
DD-ECL-002-Q031 Medium

Over the limit

Append FactOpenItemsLatest to FactOpenItems first. How many customers in the group owe more than their CreditLimit (both in their company's currency) at the latest month end in the data (30 September 2026)?
Expected
One whole number · KPI card
Tables
FactOpenItems, FactOpenItemsLatest, DimCustomer · columns
  • FactOpenItems
  • FactOpenItemsLatest
  • DimCustomer
  • OpenAmount
  • CreditLimit
  • CustomerCode
  • SnapshotDate

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