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

Group receivables today

Append FactOpenItemsLatest to FactOpenItems first. Group amounts are in AED: multiply KSA amounts by its RateToAED in DimEntity. What are the group's total receivables 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, DimEntity · columns
  • FactOpenItems
  • FactOpenItemsLatest
  • DimEntity
  • OpenAmount
  • EntityCode
  • RateToAED
  • SnapshotDate

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