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

Logistics underpaid gratuity

UAE gratuity: none below 1 year of service; 21 days of basic salary (BasicAtExit / 30) for each of the first 5 years, 30 days for each year after, capped at 24 months of basic; years = (LastWorkingDay - HireDate + 1) / 365. For Mizan Logistics exits whose settlement was paid (SettlementPaidOn) before 1 July 2025, what is the total shortfall of GratuityPaid against the law (ignore any overpayment), in USD?
Expected
One amount in USD, 2 decimals · KPI card
Tables
FactExit, DimEmployee · columns
  • FactExit
  • DimEmployee
  • GratuityPaid
  • BasicAtExit
  • LastWorkingDay
  • SettlementPaidOn
  • 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