UAE debt older than 180 days
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 is the UAE company's total OpenAmount in the 180+ bucket at the latest month end in the data (30 September 2026), in AED?
- Expected
- One amount in AED, 2 decimals · KPI card
- Tables
-
FactOpenItems, FactOpenItemsLatest · columns
- Topics
- Collections & Receivables