Skip to main content
DD-HRM-002 Mizan Manufacturing and Logistics: Two Payrolls, One Ledger — HR & Payroll Analytics Get the data →
DD-HRM-002-Q012 Easy

UAE nationals on the payroll

An employee is on the payroll at a date when HireDate is on or before it and LastWorkingDay is blank or after it. How many UAE nationals (Nationality "United Arab Emirates") were on the payroll on 31 December 2025?
Expected
One whole number · KPI card
Tables
DimEmployee · columns
  • DimEmployee
  • Nationality
  • HireDate
  • LastWorkingDay

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

Create a free account Sign in