Group allowance movement
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. By how much did the group's total allowance change from 31 December 2025 to the latest month end in the data (30 September 2026), in AED?
- Expected
- One amount in AED, 2 decimals · KPI card
- Tables
-
FactOpenItems, FactOpenItemsLatest, DimCustomer, FactLossRates +2 · columns