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