Skip to main content
DD-HRM-004-Q027 Hard

Overtime nobody approved

How many overtime hours of 2025 were paid (FactPayroll "Overtime" Hours) for an employee and PeriodKey with no row in FactOvertimeApproval? 2 decimals.
Expected
One number, 2 decimals · KPI card
Tables
FactPayroll, FactOvertimeApproval · columns
  • FactPayroll
  • FactOvertimeApproval
  • PayElement
  • Hours
  • EmployeeID
  • PeriodKey

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