Group coverage
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). The allowance policy at a month end: a customer whose CreditImpairedDate is on or before it is provided at OpenAmount x (100 - ExpectedRecoveryPct)% - the specific allowance. Every other open item: OpenAmount x LossRatePct% x FLI - the collective allowance - where LossRatePct comes from its entity's MatrixVersion in force (latest EffectiveFrom on or before the date) for the customer's Segment and the item's Bucket, and FLI is the forward-looking factor of the customer's Segment: the sum of Weight x Multiplier over the scenarios of its entity's ScenarioSet in force (latest ValidFrom on or before the date). Group amounts are in AED: multiply KSA amounts by its RateToAED in DimEntity. What is the group's total allowance as a percentage of its total receivables at the latest month end in the data (30 September 2026)? 2 decimals.
- Expected
- One percentage, 2 decimals · KPI card
- Tables
-
FactOpenItems, FactOpenItemsLatest, DimCustomer, FactLossRates +2 · columns