Approved above the limit

How many "Approved for payment" events were made by a user whose ApprovalLimit (DimUser) is below the invoice Amount?

Expected: One whole number · KPI card
Tables: FactInvoiceEvent, FactInvoice, DimUser · columns

FactInvoiceEvent
FactInvoice
DimUser

InvoiceID
Activity
EventTimestamp
UserID
Amount
ApprovalLimit
Topics: Risk & Controls

Discussion

No one has posted here yet. Ask something, compare your result, or share how you solved it.

Join the discussion

A free account takes a minute. Your draft is kept while you sign in. Need help? Message us

Create a free account Sign in