Skip to main content
DD-ECL-002-Q005 Easy

How much KSA has overdue

Append FactOpenItemsLatest to FactOpenItems first. Days past due (DPD) = the SnapshotDate minus the DueDate in days. Buckets: Current (DPD 0 or less), 1-30, 31-60, 61-90, 91-180, 180+ (over 180). What share of the KSA company's total OpenAmount at the latest month end in the data (30 September 2026) is past due (DPD above 0)? 2 decimals.
Expected
One percentage, 2 decimals · KPI card
Tables
FactOpenItems, FactOpenItemsLatest · columns
  • FactOpenItems
  • FactOpenItemsLatest
  • OpenAmount
  • DueDate
  • SnapshotDate
  • EntityCode

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