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

Gratuity underpaid

Gratuity (UAE Federal Decree-Law 33 of 2021): from one year of service, BasicAtExit / 30 x (21 days for each of the first five years + 30 days for each year after), years = (LastWorkingDay - HireDate + 1 day) / 365, capped at 24 x BasicAtExit; nothing under one year. Recalculate every exit. How many received more than 1 USD less than the law gives?
Expected
One whole number · KPI card
Tables
FactExit, DimEmployee · columns
  • FactExit
  • DimEmployee
  • GratuityPaid
  • BasicAtExit
  • LastWorkingDay
  • HireDate

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