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

Recoveries across the group

Group amounts are in AED: multiply KSA amounts by its RateToAED in DimEntity. What is the total of all "Recovery" events in the window across both companies, in AED?
Expected
One amount in AED, 2 decimals · KPI card
Tables
FactCreditEvents, DimEntity · columns
  • FactCreditEvents
  • DimEntity
  • Amount
  • EventType
  • EntityCode
  • RateToAED

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